SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-15
SQLCATOBUFFER
first-record-number input
INT16
is the ordinal number of the error record (line) to be moved to the output buffer.
The procedure discards any error records with a lower number. If the call
statement omits this parameter, the value 1 is the default. The count of lines
moved begins with 1.
To obtain more than one error record, you must increment the value in
firstrecord- number. See Examples on page 4-18.
output-records output
INT16
is the number of records (lines) moved by SQLCATOBUFFER to output-
buffer.
more output
INT16
returns a flag that indicates whether all the desired lines fit into the output-
buffer. The values and their meanings are:
To check the value in more, use ORD(‘Y’) or ORD(‘N’); see Examples on
page 4-18.
out-record-length input
INT16
defines the length of records to be written to the output buffer; the length must
be an integer value in the range of 60 through 600. If the call statement omits
this parameter, the default length is 79 bytes.
The procedure pads each line with blanks and adds the suffix and prefix strings
if the call specifies them.
sql-msg-file-number input/output
INT16
contains the file number of the SQLMSG file. If you pass -1 on input, the
system opens the SQLMSG file and returns the resulting file number. If you
pass a value other than -1, the system uses that value as the file number of the
SQLMSG file.
Y There were additional records; the buffer overflowed
N There are no additional records