Command Facility › Special Coding for Command Facility Statements

Special Coding for Command Facility Statements

As an alternative to switching to the command facility compiler, you can submit command facility statements using the command facility. You can submit command facility statements singly or as a block of statements. These two methods are described as follows. Also the considerations are described when you need to submit a command facility SIGNON statement.

Submitting a Single Command Facility Statement

Submit the statement as you would to the command facility compiler except end each statement with a semicolon. Each statement is processed in a separate call to the command facility compiler.

If an entity type is ambiguous, precede it in syntax with the keywords command facility. For example, to differentiate a COMMAND FACILITY FILE from a DDL FILE, add the keywords command facility:

add command facility file name is ...
display all command facility files.

You can mix command facility statements with other statements you submit using the command facility.

Submitting a Block of Command Facility Statements

If you want to enter several command facility statements without making several calls to the command facility compiler, you can submit the command facility statements as a block. Place the command EXECIDD on a separate line preceding the command facility statements, and place the command ENDIDD on a separate line following the command facility statements. You can use a period or semicolon to terminate each command facility statement.

The following is an example of submitting multiple command facility statements for processing in a single call to the command facility compiler:

EXECIDD
add attribute sql within class language.
add module sqlsel language sql
   module source follows
       select * from employee
       where proj_leader_id = emp_id
       and proj_id = project_number;
   msend.
ENDIDD

When to Enter a COMMAND FACILITY SIGNON Statement

Appropriate COMMAND FACILITY SIGNONs are generated when you enter command facility statements singly or as a block.

However, when your signon user ID for a command facility secured dictionary does not match your signon user ID for the system, enter a COMMAND FACILITY SIGNON statement as the first statement following EXECIDD. This signon must include the user ID and password required to access the secured dictionary.