SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-30
Superseded Procedures
Superseded Procedures
The SQLCADISPLAY and SQLCATOBUFFER procedures have been superseded by
the SQLCA_DISPLAY2_ and SQLCA_TOBUFFER2_ procedures, respectively. The
data type of parameters in the SQLCA_DISPLAY2_ and SQLCA_TOBUFFER2_ make
those procedures easier to use in COBOL programs. These procedures are included in
this manual for compatibility with earlier PVUs.
SQLCADISPLAY
The SQLCADISPLAY procedure displays the error or warning messages returned to
the SQLCA structure. This procedure displays the information to a file or to a terminal.
The error or warning messages can be from these subsystems or system components:

SQL/MP

NonStop OS

File system

Disk process (DP2)

FastSort program (SORTPROG process)

Sequential I/O (SIO) procedures
sqlca required input
is the record name of the SQLCA to be displayed. The SQLCA is declared
automatically when you include the INCLUDE SQLCA directive.
output-file-number optional input
PIC S9(4) COMP
is the output file number. If you omit this value or set it to a negative value,
SQLCADISPLAY displays information at your home terminal. SQL/MP ignores this
parameter if detail-params specifies sequential I/O (SIO).
ENTER TAL "SQLCADISPLAY" USING
sqlca,
[ output-file-number, ]
[ output-record-length, ]
[ sql-msg-file-number, ]
[ errors, ]
[ warnings, ]
[ statistics, ]
[ caller-error-loc, ]
[ internal-error-loc, ]
[ prefix, ]
[ prefix-length, ]
[ suffix, ]
[ suffix-length, ]
[ detail-params ].