SQL Supplement for H-Series RVUs

SQL/MP Programming Manual for COBOL
HP NonStop SQL Supplement for H-Series RVUs—529446-005
1-14
Preparing for Compilation
SQL Compiler Directive
The SQL compiler directive indicates to the HP COBOL compiler that a program
contains embedded SQL statements or directives and specifies various options for
processing the SQL statements or directives. Use this syntax for the SQL directive:
PAGES num-pages
specifies the number of 2048-byte pages of memory the compiler allocates to the
SQL compiler interface (SCI) to process SQL statements and directives. The
default (and minimum) value for num-pages is 560 (on TNS/R systems) or 860
(on TNS/E systems). The maximum value is 1000.
SQLMAP
directs the compiler to include an SQL map in the listing file. An SQL map contains
this information:
•
Each run-time data unit (RTDU), which is a region of the object file that
contains both SQL source statements and object code
•
Section location table (SLT) index number, which maps a single SQL statement
to a table in the RTDU
•
Source file name and number
•
Source file line number
The SQL map is sorted first by RTDU name and then by SLT index number. You
can use this map to correlate MEASURE output with the SQL statements.
The SQLMAP option also directs the compiler to include the HOSV version in the
compiler listing. For example:
Host Object SQL Version = 315
The default is not to include the SQL map in the listing.
WHENEVERLIST
directs the compiler to write active WHENEVER options to the listing file after each
embedded SQL statement is processed.
SQL [ sql-option-list | ( sql-option-list )]
sql-option-list is:
sql-option[, sql-option]...
sql-option is:
PAGES num-pages
| SQLMAP
| WHENEVERLIST
| { RELEASE1 | RELEASE2 }