SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-37
SQLCATOBUFFER
statistics optional input
PIC S9(4) COMP
controls the writing of statistics to the buffer:
The default is Y.
caller-error-loc optional input
PIC S9(4) COMP
controls the writing of the program name and line number of the SQL statement
that received the error:
The default is Y.
internal-error-loc optional input
PIC S9(4) COMP
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.
Y Write row and cost statistics if the value returned to the SQLCA in the
ROW or COST field is greater than or equal to 0.
N Do not write statistics.
R Write row statistics only.
C Write cost statistics only.
Y Write the program name and line number.
N Suppress the information.
Y Write the location.
N Suppress the information.