SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-24
SQLSADISPLAY
Table 4-5 describes the elements shown in Figure 4-1.
Example
A program performs the following functions:
1. Includes the SQLSA and SQLCA structures at compile time
2. Executes an SQL DML statement
3. Calls the SQLSADISPLAY procedure as follows:
SQLSADISPLAY ( XADDR(SQLSA), XADDR(SQLCA) );
Figure 4-1. SQLSADISPLAY Display Format
Table 4-5. SQLSADISPLAY Procedure Display Elements
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 CPU and PIN of the calling program
Table Name The name of each table
Records Accessed The number of records accessed in each table (includes
records examined by the disk process, file system, and
NonStop 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.
Table Name
Records
Accessed
Records
Used
Disc
Reads
Message
Count
Message
Bytes
Lock
WE
SQL statistics @ \ system.$ vol. subvol. file.# line process cpu,pin
VST0401.vsd