(DQD60) Editor (For Wide Screens)

Panels › (DQD60) Editor (For Wide Screens)

(DQD60) Editor (For Wide Screens)

 =>
 CREATION PANEL
 --------------------------------------------------------------------------DQD60
 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> NOT USED       <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 Administrator authorization also use it to create, copy or modify conditions and JCL.)

The CA Dataquery 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 may change only 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 Editor Commands 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 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	1 to 15 characters beginning with a letter.	No default
TYPE:	Y	Query, Term, or Dialog. CA Dataquery 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. For details on using the Editor to create JCL and other members, see the CA Dataquery Administrator Guide.	No default
STATUS:	Y	Private or Public.	Private
DESCRIPTION:	N	1 to 60 characters.	No default
Line numbers	N	Editor line commands. See Editor Commands.	No default

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 language statements.
<PF10> VALIDATE: Screens the current entries on the Editor panel for errors.
<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 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.