Accessing the EDITOR

Using the CA Dataquery EDITOR › Accessing the EDITOR

Accessing the EDITOR

Display the CA Dataquery EDITOR in one of the following ways:

Select CREATE from the Main Menu.
Type CREATE in the command line on any panel.
Use <PF4> EDIT on any panel which displays this option, such as directory panels.
Type EDIT query-name in the command line on any panel. The query-name entry must be the name of an existing query or dialog that you want to view, change or copy.
Type EDIT * to display the active query.
Type DRAW table-name to create a query listing all columns that you can access in the named table.

The CA Dataquery EDITOR allows you to type directly on the screen or select items from other displays to be included in the text. You can display and make selections from a template of clauses, a list of tables for your current ID, and from a list of columns in any table you select. Operate the EDITOR by entering commands and by pressing PF keys.

The following example shows the EDITOR as it appears with no entries.

Parts of the CA Dataquery EDITOR

 =>  
 CREATION PANEL 
 ------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR            CURRENT TABLE:  ________________________________
 -----------------------------------------------------------------------------
 NAME:  _______________              TYPE: ______  STATUS: _______
 DESCRIPTION:  _______________________________________________________________
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 .. ================================ T O P =====================================
 ..
                                     
 ..
 ..
 ..
    ===========================  B O T T O M  ==================================
 -------------------------------------------------------------------------------
 <PF1> HELP         <PF2>  RETURN      <PF3> DISPLAY COLUMNS <PF4> DISPLAY KEYS
 <PF5> DISPLAY ALL  <PF6>  LIST TABLES <PF7> BACKWARD        <PF8>  FORWARD
 <PF9> TEMPLATE     <PF10> VALIDATE    <PF11> RIGHT/LEFT     <PF12> PROCESS MODE

Description

Name	Purpose
Command line	Enter CA Dataquery system commands.
Mode prompt	Displays current EDITOR mode: Create or Process.
Description area	Describes query or dialog. Entries can be changed.
Line commands	Enter EDITOR commands in this area.
Text area (TOP to BOTTOM)	Type clauses or insert them from the template on these lines. Also insert table and column names that you select from displays accessed by <PF6> LIST TABLES and <PF3> DISPLAY COLUMNS.
PF key menu	Create Mode keys or Process Mode keys. Change modes with <PF12> PROCESS MODE.