SQL Programming Manual for Pascal

Error and Status Processing
HP NonStop SQL Programming Manual for Pascal—528614-001
6-11
Using the SQLSA
Table 6-3 describes the fields in the SQLSA data structure.
Figure 6-1. SQLSA Record Description
Table 6-3. SQLSA Fields (page1of3)
Field Description
eye_catcher Identification field, set by the system to SA.
version Current version of the SQLSA; subsequent NonStop SQL
software releases can change this version ID.
dml Record where statistics on DML statement execution are
returned.
END ;
TYPE
STATS_TYPE = RECORD
table_name : FSTRING(24);
records_accessed : LONGINT;
records_used : LONGINT;
disk_reads : LONGINT;
messages : LONGINT;
message_bytes : LONGINT;
waits : INTEGER;
escalations : INTEGER;
sqlsa_reserved : FSTRING(24);
END ;
DML_TYPE = RECORD
num_tables : INTEGER;
stats : ARRAY [1..16] OF STATS_TYPE;
END ;
PREPARE_TYPE = RECORD
input_num : INTEGER;
input_names_len : INTEGER;
output_num : INTEGER;
output_names_len : INTEGER;
name_map_len : INTEGER;
sql_statement_type : INTEGER;
SQLSA_TYPE = RECORD
eye_catcher : FSTRING(2);
version : INTEGER;
CASE INTEGER OF
1: (dml : DML_TYPE);
2: (prepare : PREPARE_TYPE);
END ;
VAR
sqlsa : SQLSA_TYPE;
VST0601.vsd