SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-16
SQLCATOBUFFER
To improve the performance of a program that makes multiple calls to the
SQLCADISPLAY or SQLCATOBUFFER procedures, specify a variable
containing -1 on the first call and then use the returned file number for
subsequent calls. By using the file number, the system opens the file only once
and uses the file number for subsequent calls; otherwise, the system opens the
file for each call.
errors input
CHAR
controls the writing of error messages. The values you can specify and their
meanings are:
ERROR from subsystem [nn]:
The default is Y.
warnings input
CHAR
controls the writing of warning messages. The values you can specify and their
meanings are:
WARNING from subsystem [nn]:
The default is Y.
statistics input
CHAR
controls the writing of statistics. The valid values for this parameter and the
statistics each designates are:
If the call statement omits this parameter, Y is the default.
N Write only the first error
Y Write all errors
B Write all errors but suppress the prefix:
N Display no warning messages
Y Display all warning messages
B Display all warnings but suppress the prefix:
Y Display 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 Display rows only
C Display cost only
N Display no statistics