SQL Programming Manual for TAL

Error and Status Processing
HP NonStop SQL Programming Manual for TAL—527887-001
6-12
Getting Performance and Statistics Information
NUM^TABLES Number of tables accessed by a DML statement. Maximum
is 16.
STATS Array containing NUM^TABLES valid entries, one for each
table accessed.
TABLE^NAME Guardian internal file name of the table accessed.
RECORDS^ACCESSED Number of records accessed in the corresponding table.
RECORDS^USED Number of records altered or returned.
DISC^READS Number of disk reads and writes.
MESSAGES Number of messages sent to the disk process.
MESSAGE^BYTES Number of bytes sent in all the messages sent to the disk
process.
WAITS Number of lock waits or timeouts.
ESCALATIONS Number of times record locks are escalated to file locks.
SQLSA^RESERVED Reserved
PREPARE Structure to which statistics on a PREPARE statement are
returned. This structure applies only for dynamic SQL. The
information provided is used by your program to allocate
the buffers required to describe the prepared statement.
INOUT^NUM Number of input parameters in the prepared statement.
INPUT^NAMES^LENGTH Length of the buffer required to contain names of input
parameters.
Table 6-3. SQLSA Fields (page2of3)
Field Name Description