SQL Programming Manual for Pascal
NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-23
SQLSADISPLAY
detail_params input
(record)
determines whether the program uses sequential I/O or Enscribe I/O for writing
to the output file. detail_params points to a structure with this declaration:
sio
specifies whether sequential I/O is used and can have the following values:
outfcb1
specifies the first output file control block if sio is enabled.
outfcb2
specifies the second output file control block if sio is enabled. To use
outfcb2, assign it a value greater than 0.
The default is Enscribe I/O.
Guidelines
Because the PREPARE statement continually redefines the fields of the SQLSA during
the execution of dynamic SQL statements, SQLSADISPLAY cannot display an SQLSA
returned by a PREPARE statement.
Display Format
SQLSADISPLAY displays statistics in the format shown in Figure 4-1:
TYPE SQLCADisplayStruct = RECORD
filler: CHAR;
sio: CHAR;
outfcb1: EXTADDR;
outfcb2: EXTADDR;
END;
Y Use sequential I/O; ignore out_file_num
N Do not use sequential I/O; write to out_file_num