Using the Interactive SQL Service Facility › Using Commands

Using Commands

In the Interactive SQL Service Facility, you can make your selections through menu and prompter panels or by entering commands in the command lines of the panels.

Note: For complete information on using CA Datacom Datadictionary online, see the CA Datacom Datadictionary User Guide or CA Datacom Datadictionary Online Reference Guide.

The abbreviated command syntax for the menu options is displayed on the panels to help you learn the commands easily. The full and abbreviated command syntax for functions performed by the prompter panels are displayed on those panels.

You can skip the prompter panel by entering these commands. However, if the complete command is longer than the 76 spaces available in a command line, you must use the prompter panel. A command cannot be continued to another line.

You can display HELP panels for most commands by entering HELP, followed by the command. The HELP panel explains the functions and options for using that particular command.

To issue commands to CA Datacom Datadictionary, enter the command in the command region (region 0) at the top of the panel and then press Enter. If a command is only valid in a specific processing mode, you must select the appropriate mode before you enter the command. You can select a processing mode by entering the appropriate option on the Datadictionary Mode Select Panel or by entering the SET MODE command with the selected mode identifier.

Except where noted, you can enter more than one command on a panel as shown in the following examples. You can change the number of command lines displayed with the SET CMD LIN command. See the CA Datacom Datadictionary Online Reference Guide for details.

• You can type each command on a separate line. For example:

 => SET MODE SQL
 => EDIT SQL
 =>
 
 -------------------------------------------------------------------------------

• Or, you can type several commands on the same line and separate them with a semicolon, the default delimiter. You can change the delimiter with the SET CMD DLM command. See the CA Datacom Datadictionary Online Reference Guide for details. For example:

 => SET MODE SQL;EDIT SQL
 =>
 =>
 
 -------------------------------------------------------------------------------

When you enter only a portion of a command, CA Datacom Datadictionary presents the prompter panel or menu for that function with the information you have filled in on the panel.

Remember that on a prompter panel, you must do the following:

• Supply all required entries.
• Supply any desired optional entries.
• Press Enter or PF9 (APPLY) to continue processing.

You can use the following general commands in the Interactive SQL Service Facility. See the CA Datacom Datadictionary Online Reference Guide for explanations of the commands in the following list.

• BOTTOM
• COMBINE
• END
• HELP
• INPUT
• MENU
• OFF
• POSITION
• PROCESS
• SET
• SPLIT
• STATUS
• SRB
• SRF
• TIME