SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-4
SQLCADISPLAY
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
INT
controls the display of error messages. The values you can specify and their
meanings are:
N Display only the first error.
Y Display all errors.
B Display all errors but suppress this prefix:
ERROR from subsystem [nn]:
The default is Y.
warnings input
INT
controls the display of warning messages. The values you can specify and their
meanings are:
N Display no warning messages.
Y Display all warning messages.
B Display all warnings but suppress the prefix:
WARNING from subsytem [nn]:
The default is Y.
statistics input
INT
controls the display of statistics. The values you can specify and their meanings
are:
Y Display row and cost statistics if the value returned to the SQLCA in the ROW or
COST field is greater than or equal to 0.
R Display rows only.
C Display cost only.
N Display no statistics.
The default is Y.