Editor Commands

Use the CA Dataquery Editor and your knowledge of DQL or SQL to build queries, dialogs and terms ranging from the simple to the complex. To aid you in your task, the Editor has line commands you use to insert, copy, move, delete, repeat and split lines, and commands which allow you to shift the position of data within a line, locate or change character strings, and scroll text forward and backward.

Special Aids

PF keys are available when you are building your query to display database information, and a template from which you can select statements to insert into query text on the Editor panel. Other PF keys allow you to scroll forward and backward if your query is more than one panel long or left and right if your terminal is an 80-character width display. Another special PF key, available in both modes, lets you validate your query, that is, check for errors in syntax and names of database tables, columns and keys.

Editor Modes

The Editor panel provides you with a Create mode where you build your query and a Process mode where you can perform such functions as executing, saving and deleting queries. A special PF key allows you to switch back and forth between these two modes.

Note: For information about using the CA Dataquery Editor to create queries, dialogs, report definitions and terms, see the CA Dataquery User Guide.

Create Mode

Selecting CREATE from the Main Menu or typing CREATE in the command line on any panel displays the Editor panel in Create mode. Using this panel, you can:

Insert keyword formats selected from the template or type in statements in the space provided on the panel.
Insert any comments that you want to exclude from the query by preceding them with the characters used at your site. If your site does not use the default */ to begin a comment and /* to end a comment, see your CA Dataquery Administrator for the characters used.
Display database information using PF keys, and insert table, column and key names at the appropriate location in query statements.
Use the CA Dataquery Editor commands to insert, copy, move, repeat, delete and split lines; scroll the display to a specific line; shift data left or right within a line; locate and change strings within the query.
Validate the query, that is, check for errors in table, column and key names and syntax.
Access the Editor panel in Process mode.

Process Mode

Selecting the EDIT option (<PF4> EDIT) on any Directory panel where this option is available or typing EDIT query-name in the command line on any panel displays the Editor panel in Process mode. The query-name entry must be the name of an existing query or dialog. Using this panel, you can:

Save the query you have just created.
Execute the query you have just created or updated.
Delete the query displayed on this panel.
Update a saved query of your own which is displayed on this panel.
Validate the query you have just created, saved or updated.
Select the dialog definition option to create a dialog. (See the CA Dataquery User Guide for an overview of dialog creation.)
Access the Editor panel in Create mode.
Use the CA Dataquery Editor commands to insert, copy, move, repeat, delete and split lines; scroll the display to a specific line; shift data left or right within a line; locate and change strings within the query.