Input

For batch, the input must be in columns 1 to 72 or 80. The default is 72. You can change the default by using the SYSIDMS parameter BCF_INPUT_80. For more information, see SYSIDMS parameter file chapter. For online, the input must be in columns 1 to 79.

Can be uppercase or lowercase characters (or mixed).

A statement can span any number of input lines. You can submit multiple statements on the same input line.

Syntax

Use the syntax rules that apply to the type of statement:

• Physical DDL—See the CA IDMS Database Administration Guide.
• Logical DDL (SQL-defined databases)—See the CA IDMS SQL Reference Guide.
• SQL DML—See the CA IDMS SQL Reference Guide.
• Utilities—See the CA IDMS Utilities Guide.
• Security administration—See the CA IDMS Security Administration Guide.

Statement terminator

End each statement with a command terminator or delimiter. Initially the command terminator is the semicolon (;), but it can be modified by the SET OPTIONS COMMAND DELIMITER command. The command delimiter can be on the line with the statement, or it can be on the line following the statement.

You can omit the terminator at the end of your last statement.

Comments

Begin comments with a double hyphen (--). Comments continue to the end of an input line.

Connecting to a dictionary

Use a CONNECT statement in a batch or online command facility session (see Connecting to a Dictionary)

Session control

Use the SET OPTIONS statement (see Using SET OPTIONS to Select Options)

Output formatting control

Use the SET OPTIONS statement (see Using SET OPTIONS to Select Options)