SQL Programming Manual for Pascal

Error and Status Processing
HP NonStop SQL Programming Manual for Pascal—528614-001
6-12
Using the SQLSA
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 NonStop Kernel operating system 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.
disk_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 Record 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.
input_num Number of input parameters in the prepared statement.
input_names_len Length of the buffer required to contain names of input
parameters.
output_num Number of output variables in the prepared statement. Output
variables are host variables or SELECT columns.
Table 6-3. SQLSA Fields (page2of3)
Field Description