SQL/MP Programming Manual for C

Error and Status Reporting
HP NonStop SQL/MP Programming Manual for C—429847-008
9-17
Using the SQLSA Structure
Table 9-5. SQLSA Structure Fields (page 1 of 2)
Field Name Description
eye_catcher
Identification field. Set eye_catcher to
SQLSA_EYE_CATCHER.
version
Current product version of SQLSA. (Subsequent
NonStop SQL/MP PVUs can change this value.)
dml
Structure for the return of statistics after the execution
of a DML statement.
num_tables
Number of tables accessed by a DML statement;
maximum is 16.
master_executor_elapsed_
time
CPU time in microseconds used by the master
Executor process. Applies only to a version 330 or
later SQLSA structure.
total_esp_cpu_time
Total CPU time in microseconds used by all Executor
Server Processes (ESPs). Applies only to a version
330 or later SQLSA structure.
total_sortprog_cpu_time
Total CPU time in microseconds used by all
SORTPROG processes. Applies only to a version 330
or later SQLSA structure.
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 time outs.
escalations
Number of times record locks are escalated to file
locks.
sqlsa_reserved
Reserved.
vsbb_write
True (-1) if a VSBB write was used. Otherwise, false
(0).
vsbb_flushed
True (-1) if the VSBB buffer was flushed. Otherwise,
false (0).
prepare
Structure for the return of statistics for a PREPARE
statement. Applies only to dynamic SQL statements.
A program can use this information to allocate the
buffers required to describe the prepared statement.