SQL/MP Programming Manual for COBOL

Error and Status Reporting
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
9-23
Returning Performance and Statistics Information
Table 9-2 describes each SQLSA structure field.
Example 9-3. SQLSA Structure
01 SQLSA.
02 EYE-CATCHER PIC X(2) VALUE "SA".
02 VERSION PIC S9(4) COMP VALUE 0.
02 DML.
03 NUM-TABLES PIC 9(4) COMP VALUE 0.
03 STATS OCCURS 16 TIMES.
04 TABLE-NAME PIC X(24) VALUE SPACES.
04 RECORDS-ACCESSED PIC S9(9) COMP VALUE 0.
04 RECORDS-USED PIC S9(9) COMP VALUE 0.
04 DISC-READS PIC S9(9) COMP VALUE 0.
04 MESSAGES PIC S9(9) COMP VALUE 0.
04 MESSAGE-BYTES PIC S9(9) COMP VALUE 0.
04 WAITS PIC S9(4) COMP VALUE 0.
04 ESCALATIONS PIC S9(4) COMP VALUE 0.
04 SQLSA-RESERVED PIC X(4) VALUE SPACES.
02 PREPARE REDEFINES DML.
03 INPUT-NUM PIC 9(4) COMP.
03 INPUT-NAMES-LEN PIC 9(4) COMP.
03 OUTPUT-NUM PIC 9(4) COMP.
03 OUTPUT-NAMES-LEN PIC 9(4) COMP.
03 NAME-MAP-LEN PIC 9(4) COMP.
03 SQL-STATEMENT-TYPE PIC 9(4) COMP.
88 SQL-STATEMENT-SELECT VALUE 1.
88 SQL-STATEMENT-INSERT VALUE 2.
88 SQL-STATEMENT-UPDATE VALUE 3.
88 SQL-STATEMENT-DELETE VALUE 4.
88 SQL-STATEMENT-DDL VALUE 5.
88 SQL-STATEMENT-CONTROL VALUE 6.
88 SQL-STATEMENT-DCL VALUE 7.
88 SQL-STATEMENT-GET VALUE 8.
03 OUTPUT-COLLATIONS-LEN PIC 9(4) COMP.
Table 9-2. SQLSA Structure Fields (page 1 of 2)
Field Name Description
EYE-CATCHER Identification field. The compiler sets EYE-CATCHER to SA.
VERSION Current version of the SQLSA.
DML Group item where statistics for DML statement execution are
returned.
NUM-TABLES Number of tables accessed by a DML statement. The
maximum number 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.