SQL Programming Manual for Pascal

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for Pascal—528614-001
3-36
UPDATE
SQLMAP | NOSQLMAP
specifies adding information to the listing to enable you to determine corresponding
SQL statements from MEASURE output. A MEASURE report for an SQL
statement identifies the statement by the name of its run-time data unit (RTDU)
and by its index in the section location table (SLT). An RTDU is an internal SQL
data structure that resides in the code file and contains the SQL object generated
for each procedure or subprocedure. The SLT index provides a mapping from the
section location table in the RTDU to a single SQL statement and its related
information.
The information appears at the end of the compilation, in a table sorted first by
RTDU name and second by SLT index number. The values are provided:
•
RTDU name for the statement
•
SLT index number for the statement
•
RTDU name for the global run-time data unit
•
SLT index number for each cursor declaration and CONTROL statement that
appears in the global declarations
•
Source file name
•
EDIT line number
You can use this table to correlate MEASURE output with the SQL statement.
The default is NOSQLMAP.
WHENEVERLIST | NOWHENEVERLIST
controls writing active WHENEVER options to the listing file after each SQL
statement is processed.
WHENEVERLIST
specifies writing the options.
NOWHENEVERLIST
specifies that WHENEVER options are not written.
The default is NOWHENEVERLIST.
UPDATE
The UPDATE statement updates values in one or more columns in a row or set of rows
of a table or a protection view. The number of rows is determined by the WHERE
clause. An UPDATE statement can update:
•
A single row