SQL Programming Manual for TAL

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for TAL—527887-001
3-37
SQLMEM
SQLMAP | NOSQLMAP
specifies whether the compiler listing includes an SQL map. This map enables you
to determine SQL statements using output from the Measure program.
SQLMAP
causes an SQL map to be added at the end of the compiler listing. An SQL
map is a table that contains the:
•
Run-time data unit (RTDU) name in the format:
•
_SQLRTDU_ julian-timestamp
•
Section location table (SLT) index number
•
Source file name
•
Source file line number
The table is sorted first by RTDU name and then by SLT index number. You
can use this table to correlate Measure output with the SQL statement.
The global RTDU contains the cursors and CONTROL directives that are
declared in the global declarations.
NOSQLMAP
causes the SQL map not to be added. NOSQLMAP is the default.
SQLMEM
The SQLMEM TAL compiler directive specifies where in memory the TAL compiler
places the SQLIN, SQLIVARS, and SQLOVARS SQL data structures. These data
structures, which describe SQL statements and host variables, are passed to the SQL
executor at run time. Although your program does not explicitly declare these
structures and cannot directly access them, you can control their placement in
memory.
Table 3-3 shows the internal data structures and when each structure is generated.