SQL/MP Programming Manual for COBOL85

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
5-28
SQLSADISPLAY
detail-params optional input
determines whether sequential I/O (SIO) or Enscribe I/O is used for writing to the
output file. A COBOL program usually omits detail-params and uses Enscribe
I/O (the default). The parameter detail-params points to a structure with this
TAL declaration:
STRUCT detail^params;
BEGIN
sio STRING;
out^fcb^1 INT .EXT;
out^fcb^2 INT .EXT;
END;
sio
specifies whether sequential I/O is used:
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.
Example of the SQLSADISPLAY Display
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
Y Use SIO; ignore output-file-number.
N Do not use SIO; write to output-file-number.