SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-34
SQLCATOBUFFER
Example
This SQLCADISPLAY statement uses all default values:
ENTER TAL “SQLCADISPLAY” USING SQLCA.
SQLCATOBUFFER
The SQLCATOBUFFER procedure writes to a buffer the error or warning messages
returned by SQL/MP. The buffer is a record area declared in the Working-Storage or
Extended-Storage Section of the program.
The information returned to the buffer can originate from these subsystems or system
components:

SQL/MP

NonStop OS

File system

Disk process (DP2)

FastSort program (SORTPROG process)

Sequential I/O (SIO) procedures
This procedure is similar to the SQLCADISPLAY procedure, which writes error
information to a file or terminal.
sqlca required input
is the record name of the SQLCA.
The SQLCA is declared automatically when you specify the INCLUDE SQLCA
directive.
ENTER TAL "SQLCATOBUFFER" USING
sqlca,
output-buffer,
output-buffer-length,
[ first-record-number, ]
[ output-records, ]
[ more, ]
[ output-record-length, ]
[ sql-msg-file-number, ]
[ errors, ]
[ warnings, ]
[ statistics, ]
[ caller-error-loc, ]
[ internal-error-loc, ]
[ prefix, ]
[ prefix-length, ]
[ suffix, ]
[ suffix-length ].