SQL/MP Programming Manual for C

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for C—429847-008
5-17
SQLCATOBUFFER
internal_error_loc
controls the writing of the system-code location where the first error in the SQLCA
occurred:
The default is Y.
prefix
is a string to precede each output line. The default is three asterisks and a
space (*** ).
prefix_length
is the length of the prefix string for each output line. The length must be an
integer from 1 to 15. If you include prefix, prefix_length is required.
suffix
is a string to be appended to each output line. The default is a null string.
suffix_length
is the length of the suffix string for each output line. The length must be an
integer value from 1 to 15. If you include suffix, prefix_length is required.
Additional considerations for the SQLCATOBUFFER procedure are:

NonStop SQL/MP returns errors as negative numbers and warnings as positive
numbers. Therefore, you might need to modify your program accordingly.

If there is no text for an error number, NonStop SQL/MP displays this message:
No error text found
If you receive this message, the version of the SQL message file might be invalid.
To determine the version of the SQL message file, use the SQLCI ENV command
and check the version specified by MESSAGEFILEVSRN.

The SQLCATOBUFFER procedure starts with the first_record_number
indicated to move output lines to the record area until all error messages are
moved or until the text fills the record area. SQLCATOBUFFER returns to
output_records a count of the lines moved to the buffer. If an overflow occurs,
the procedure sets the more flag to Y.

On an overflow condition, your program can retrieve the remainder of the error
message text by calling SQLCATOBUFFER again and setting
first_record_number to output_records + 1.
Y Write the location.
N Suppress the information.