SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-14
SQLCA_TOBUFFER2_
errors optional input
PIC X
controls the writing of error messages to the buffer:
The default is Y.
warnings optional input
PIC X
controls the writing of warning messages to the buffer:
The default is Y.
statistics optional input
PIC X
controls the writing of statistics to the buffer:
The default is Y.
caller-error-loc optional input
PIC X
controls the writing of the program name and line number of the SQL statement
that received the error:
Y Write all errors.
N Write only the first error.
B Write all errors but suppress this prefix:
ERROR from subsystem [nn]:
Y Write all warning messages.
N Do not write any warning messages.
B Write all warnings but suppress this prefix:
WARNING from subsystem [nn]
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.