SQL/MP Programming Manual for COBOL

Error and Status Reporting
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
9-24
Returning Performance and Statistics Information
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 Group item where statistics for a PREPARE statement are
returned.
INPUT-NUM Number of input parameters in the prepared statement.
INPUT-NAMES-LEN Length of the buffer required to contain names of the input
parameters.
OUTPUT-NUM Number of output variables (host variables or SELECT
columns) in the prepared statement.
OUTPUT-NAMES-LEN Length of the buffer required to contain names of the output
variables.
NAME-MAP-LEN Length of the buffer for name maps. A value is returned in this
item only if the name map will be used or saved for later use.
The system stores in name maps the context of DEFINEs,
default subvolume, and so forth.
SQL-STATEMENT-TYPE Type of statement being prepared. The values can be:
Level 88 Item Name Value SQL Statement or Directive
SQL-STATEMENT-SELECT 1 Cursor SELECT
SQL-STATEMENT-INSERT 2 INSERT
SQL-STATEMENT-UPDATE 3 UPDATE
SQL-STATEMENT-DELETE 4 DELETE
SQL-STATEMENT-DDL 5 DDL statement
SQL-STATEMENT-CONTROL 6 Run-time CONTROL TABLE
SQL-STATEMENT-DCL 7 LOCK, UNLOCK, FREE
RESOURCES
SQL-STATEMENT-GET 8 GET VERSION...
OUTPUT-COLLATIONS-
LEN
Length of the output collation buffer.
Table 9-2. SQLSA Structure Fields (page 2 of 2)
Field Name Description