(DQD10) Editor

Description
datacom
 =>    --------------------------------------------------------------------------DQD10  DATAQUERY:  EDITOR            CURRENT TABLE:  ________________________________  -------------------------------------------------------------------------------  NAME:          _______________                   TYPE: ______  STATUS: _______  DESCRIPTION:   ___________________________________________________________     ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.     ================================ T O P =====================================  01  02  03  04  05  06  07  08  09     ===========================  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
The Editor Panel appears when you select CREATE from the Main Menu, when you press an EDIT PF key during directory display, or when you use the EDIT command to display an existing query, dialog, or term. When you select CREATE (or enter the CREATE command), the Editor panel appears with the Create Mode PF keys displayed at the bottom.
When you edit (with a PF key or EDIT command), the Editor panel appears with the Process Mode PF keys displayed at the bottom and the query, dialog, or term displayed in the editing area. Use the Editor Panel to create, copy or modify a query, term, or dialog. (Users with
CA Dataquery™ for CA Datacom®
Administrator authorization also use it to create, copy or modify JCL and other member types.)
The
CA Dataquery™ for CA Datacom®
Editor is available to you for typing, inserting, moving and deleting lines between the TOP and BOTTOM lines.
In Create Mode, the PF keys allow you to display helpful information or switch to Process Mode where you use the PF keys to save, validate, process, or delete the current query or term, or to use a query as a query dialog. You can change modes with <PF12>.
Sample
Complete the fields at the top of this panel. Then write or change a query or a term in the area enclosed by the TOP and BOTTOM lines. You can only change queries, dialogs, and terms that you own. However, you can copy an existing public query by editing and renaming it. To create or edit a query, type DQL or press <PF9> TEMPLATE in Create Mode to select statement templates for your query and type valid values in place of template text (like ROW-NAME).
See for detailed instructions on using the Editor commands. See the chapters on query syntax for detailed instructions on using each DQL statement. Save your entries in Process Mode by using <PF4> SAVE or <PF9> UPDATE if you are changing an existing member.
Entry Fields
Refer to the following chart for valid entries in the fields on this panel. Use the Tab and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.
Field
Required?
Valid Entries
Default
CURRENT TABLE:
N
Name of a table you can
access
No default
NAME:
Y
Any characters except blanks
No default
TYPE:
Y
Query, Dialog, or Term
Query
STATUS:
Y
Private or Public
Private
DESCRIPTION:
N
1 to 60 characters
No default
Line numbers
N
Editor line commands
See .
No default
CA Dataquery™ for CA Datacom®
Administrators can enter other types in the TYPE field. When they do, a different PF key menu appears from the one shown in this document.
PF Keys Create Mode
The following lists the PF keys for this panel, with a brief description of each function.
  • <PF1> HELP
    Displays information about the current panel.
  • <PF2> RETURN
    Exits the current panel.
  • <PF3> DISPLAY COLUMNS
    Displays a list of all columns for the current table.
  • <PF4> DISPLAY KEYS
    Displays a list of all keys for the current table.
  • <PF5> DISPLAY ALL
    Displays a list of all keys and columns in the current table.
  • <PF6> LIST TABLES
    Displays a list of all tables your query can access.
  • <PF7> BACKWARD
    Displays the previous panel of a partially shown panel.
  • <PF8> FORWARD
    Displays the next panel of a partially shown panel.
  • <PF9> TEMPLATE
    Displays template for selecting
    CA Dataquery™ for CA Datacom®
    language statements.
  • <PF10> VALIDATE
    Screens the current entries on the Editor panel for errors.
  • <PF11> RIGHT/LEFT
    Moves current panel 4 columns left or right on 80-column terminal screens.
  • <PF12> PROCESS MODE
    Displays PF keys for processing query or term.
PF Keys Process Mode
The following lists the PF keys for this panel, with a brief description of each function.
  • <PF1> HELP
    Displays information about the current panel.
  • <PF2>RETURN
    Redisplays previous panel.
  • <PF3> EXECUTE
    Executes the query online.
  • <PF4> SAVE
    Saves the current query or term in the appropriate library.
  • <PF5> DIALOG DEF
    Defines dialog variables if variables have been entered and TYPE is
    dialog
    .
  • <PF6> DELETE
    Deletes the last version saved, if you own the member.
  • <PF7> BACKWARD
    Displays the previous panel of a partially shown panel.
  • <PF8> FORWARD
    Displays the next panel of a partially shown panel.
  • <PF9> UPDATE
    Applies any changes made to the member, if you own it.
  • <PF10> VALIDATE
    Has
    CA Dataquery™ for CA Datacom®
    check the entries for errors.
  • <PF11> RIGHT/LEFT
    Moves the panel 4 columns to the left or right, if an 80-column terminal screen.
  • <PF12> CREATE MODE
    Displays PF keys for displaying table information or template of DQL statements.