Previous Topic: Shift Line Command


Templates

This section describes those line commands that display templates of PDL and SQL constructs into the procedure of a program definition. A template contains the key words of a construct with space provided for user supplied information and an indication of what that information is. For example, the following is a template for the IF construct:

IF condition
  :statements
ELSE
  :statements
ENDIF

The user then supplies the condition and the statements in this construct.

Indentation assists you in following standard indentation practices. Each logical level in the program is indented three columns.

This command has the following format:

[n]xx[n]
n

Optionally, you can specify the number of statement lines to generate in a template wherever you can insert statements. The SET EDIT MULTIPLIER command determines whether n is placed to the left or right.

For example, specifying 3IF results in the following IF template:

IF condition
  :statements
  :statements
  :statements
ELSE
  :statements
  :statements
  :statements
ENDIF
xx

Specifies the construct whose template is entered in the procedure. You can specify the following commands:

Line Command    PDL Construct
CL              CALL USING         
ER              ERROR PROCEDURE    
FE              FOR EACH           
FF              FOR THE FIRST      
FN              FOR NEW            
IF              IF                 
LO              LOOP               
PR              PROCEDURE          
QCC             EXEC SQL CLOSE
QCM             EXEC SQL COMMIT
QDC             EXEC SQL DECLARE CURSOR
QDL             EXEC SQL DELETE
QES             EXEC SQL SELECT...INTO...
QFC             EXEC SQL FETCH
QIN             EXEC SQL INSERT
QLK             EXEC SQL LOCK TABLE
QOC             EXEC SQL OPEN
QRL             EXEC SQL ROLLBACK
QSQ             EXEC SQL SELECT...GROUP BY...
QUN             EXEC SQL UNION
QUP             EXEC SQL UPDATE
QWH             EXEC SQL WHENEVER
QXI             EXEC SQL EXECUTE IMMEDIATE
SA              SET ATTRIBUTE      
SE              SELECT EVERY ACTION
SF              SELECT FIRST ACTION
SL              SELECT identifier