SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-15
Using SQLCA_TOBUFFER2_ With an Error Table
The default is Y.
internal-error-loc optional input
PIC X
controls the writing of the system-code location where the first error in the SQLCA
occurred:
The default is Y.
prefix optional input
PIC X(length)
is a string to precede each output line. The default is three asterisks and a space
(*** ).
prefix-length optional input
PIC S9(4) COMP
is the length of the prefix string for each output line. This length must be an
integer value from 1 to 15. If you include prefix, prefix-length is required.
suffix optional input
PIC X(length)
is a string to be appended to each output line. The default is a null string.
suffix-length optional input
PIC S9(4) COMP
is the length of the suffix string for each output line. This length must be an
integer value from 1 to 15. If you include suffix, suffix-length is required.
Using SQLCA_TOBUFFER2_ With an Error Table
If you plan to write the buffer to an SQL table for subsequent access through SQLCI,
you might want to reduce the number of lines of error information and the amount of
information in each line. To reduce the line length and the number of lines, specify
SQLCA_DISPLAY2_ parameters that suppress the statistics and the internal error
location and change the prefix to a single space.
Making these changes results in two or three lines per error at the most, or a maximum
of 14 to 21 lines for the rare case where seven errors are returned. In most cases,
Y Write the location.
N Suppress the information.