SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-35
SQLCATOBUFFER
output-buffer required input/output
PIC X(length)
is the record name to which SQLCATOBUFFER writes the error information.
output-buffer-length required input
PIC S9(4)
is the length of output-buffer in bytes. This length must be

An integer value from output-record-length through 600

A multiple of output-record-length
The minimum length recommended is 300 bytes.
first-record-number optional input
PIC S9(4) COMP
is the ordinal number of the first error record (line) to be moved to the output buffer.
The procedure discards any error records with a lower number. The count of lines
moved begins with 1.
The default is 1.
To obtain more than one error record, you must increment the value in
first-record-number.
output-records optional output
PIC S9(4) COMP
is the number of records (lines) written by SQLCATOBUFFER to output-buffer.
more optional output
PIC X
is a flag that indicates whether all the desired lines fit into the output-buffer:
output-record-length optional input
PIC S9(4) COMP
defines the length of records to be written to the output-buffer. The length
must be an integer value from 60 to 600.
The default is 79 bytes.
Y There were additional records; the buffer overflowed.
N There were no additional records.