SQL/MP Programming Manual for COBOL85

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
5-29
SQLSADISPLAY
The elements of the SQLSADISPLAY procedure display are:
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.
Element Description
\system.$vol.subvol.file
The fully qualified file name of the calling program
#line
The line number of the calling program
process cpu,pin
The process ID of the calling program
Table Name
The name of each table
Records Accessed
The number of records accessed in each table (this
includes records examined by the disk process, the
file system, and the SQL executor)
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