SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-3
SQLCADISPLAY
NonStop SQL communicates error and statistics information to a program through the
SQLCA data structure. However, because the SQLCA contains information in a form
that is not suitable to display, you must call the SQLCADISPLAY procedure to convert
this information to a suitable format.
sqlca input
EXTADDR
is a pointer to the SQLCA structure, which is automatically declared when you
specify the INCLUDE SQLCA directive in the variable declarations part of the
program.
output-file-number input
INT16
is the output file number. If you omit this value or set it to a negative value,
SQLCADISPLAY displays information at your home terminal. In this case,
SQLCADISPLAY opens your home terminal, displays the message, and then
closes your terminal. NonStop SQL ignores this parameter if detail_params
specifies sequential I/O (SIO).
output-record-length input
INT16
defines the length in bytes of records to be written to the output file. The length
must be an integer value from 60 through 600. The default length is 79 bytes.
TYPE SQLCADisplayStruct = RECORD
filler: CHAR;
sio: CHAR;
outfcb1: EXTADDR;
outfcb2: EXTADDR;
END;
PROCEDURE SQLCADISPLAY TAL EXTENSIBLE
( sqlca: EXTADDR;
OPTIONAL output-file-number: INT16;
OPTIONAL output-record-length: INT16;
OPTIONAL VAR sql-msg-file-number INT16;
OPTIONAL errors: CHAR;
OPTIONAL warnings: CHAR;
OPTIONAL statistics: CHAR;
OPTIONAL caller-error-loc: CHAR;
OPTIONAL internal-error-loc: CHAR;
OPTIONAL EXTREF CONST prefix: FSTRING;
OPTIONAL EXTREF CONST suffix: FSTRING;
OPTIONAL EXTREF detail_params: SQLCADisplayStruct );