SQL Programming Manual for TAL

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for TAL—527887-001
3-3
Placing Statements and Directives in a Program
SYMBOLPAGES Directive
To use the SYMBOLPAGES directive, specify it as a compiler option in the RUN
command line for the TAL compiler when you compile the program:
TAL /IN tsrc, OUT $s.#tlst, NOWAIT / tobj; SYMBOLPAGES 2048
Data Declarations
With TAL variable declarations, you can use the:
•
BEGIN DECLARE SECTION and END DECLARE SECTION directives
•
DECLARE CURSOR statement (static cursor only, global declarations only)
•
INCLUDE SQLCA, INCLUDE SQLSA, and INCLUDE SQLDA directives
•
INVOKE directive
•
CONTROL directives
Executable Statements
With TAL executable statements, you can use the:
•
Data Control Language (DCL) statements and CONTROL directives
•
Data definition language (DDL) statements
•
Data manipulation language (DML) statements
•
Dynamic SQL statements (including DECLARE CURSOR)
•
Transaction control statements
Data Declarations and Executable Statements
Use these directives anywhere in a TAL program:
•
TAL SOURCE and SEARCH directives
•
SQL SQLMEM directive (however, you cannot use SQLMEM with the STACK
option in a subprocedure)
•
SQL WHENEVER directive