SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-16
SQLCATOBUFFER
errors input
INT
controls the error messages that are written to the buffer. The values you can
specify and their meanings are:
N Write only the first error.
Y Write all errors.
B Write all errors but suppress the prefix:
ERROR from subsystem [nn]:
The default is Y.
warnings input
INT
controls the warning messages that are written to the buffer. The values you can
specify and their meanings are:
N Write no warning messages.
Y Write all warning messages.
B Write all warnings but suppress the prefix:
WARNING from subsystem [nn]:
The default is Y.
statistics input
INT
controls the statistics that are written to the buffer. The values you can specify and
their meanings are:
Y Write row and cost statistics if the value returned to the SQLCA in the ROW or
COST data item is greater than or equal to 0.
R Write rows only.
C Write cost only.
N Write no statistics.
The default is Y.