SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-6
SQLCADISPLAY
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
•
NonStop SQL returns errors as negative numbers and warnings as positive
numbers.
•
If there is no text for an error number, NonStop SQL displays:
No error text found.
The $SYSTEM.SYSTEM.SQLMSG file contains the error text for SQL messages.
If you receive this message, your version of the SQLMSG file might not match the
version of the SQL executor.
•
If the error text exceeds output-record-length, the output is folded at word
boundaries, producing subsequent lines that are indented five spaces.
•
The SQLCA can contain a maximum of seven errors and 180 bytes of text of the
actual parameters returned to the program. Any information that exceeds these
limits is lost. SQLCADISPLAY prints a warning message that indicates when
information is lost.
TYPE SQLCADisplayStruct = RECORD
filler: CHAR;
sio: CHAR;
outfcb1: EXTADDR;
outfcb2: EXTADDR;
END;
Y Use sequential I/O; ignore output-file-number
N Do not use sequential I/O; write to output-file-number