SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-29
SQLSADISPLAY
Example 5-4 shows the information SQLSADISPLAY displays. To generate this
display, a program follows these steps:
1. Generates the SQLSA and SQLCA structures.
2. Executes an SQL DML statement.
3. Calls the SQLSADISPLAY procedure.
Records Used
The number of records actually used by the
statement
Disc Reads
The number of disk reads caused by accessing this
table
Message Count
The number of messages sent to execute operations
on this table
Message Bytes
The number of message bytes sent to access this
table
Lock WE
A flag indicating either that lock waits occurred (W) or
that lock escalations occurred (E) for the table
Example 5-4. SQLSADISPLAY Display
SQL statistics @ \sanfran.$system.accts.prog10.#333.2 process 12,255
Records Records Disc Message Message Lock
Table Name Accessed Used Reads Count Bytes WE
\sanfran.$sqlvol.accts.tab10
123 22 3 10 3245
\sanfran.$vol001.fy93.employee
9987231 1 99999 1 100 e
\sanfran.$sqlvol.accts.tab20
1 1 0 1 100 w
Element Description