SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-23
SQLSADISPLAY
sio
specifies whether sequential I/O (SIO) is used; it can have these values:
Y Use SIO; ignore out^file^number.
N Do not use SIO; write to out^file^number.
out^fcb^1
specifies the first output file control block if SIO is enabled.
out^fcb^2
specifies the second output file control block if SIO is enabled. To use this field,
assign it a value greater than 0.
Guidelines
The PREPARE statement continually redefines the fields of the SQLSA during the
execution of dynamic SQL statements. Therefore, SQLSADISPLAY cannot display an
SQLSA returned by a PREPARE statement.
SQLSADISPLAY displays statistics in this format:
SQL statistics @ \ system.$vol.subvol.file.#line process
cpu,pin
Records Records Disc Message Message Lock
Table Name Accessed Used Reads Count Bytes WE
This table describes the elements of the SQLSADISPLAY display:
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 processor 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 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