SQL Programming Manual for Pascal
NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-4
SQLCADISPLAY
sql-msg-file-number input/output
INT16
contains the file number of the SQLMSG file. If you pass -1 on input, the 
system opens the SQLMSG file and returns the resulting file number. If you 
pass a value other than -1, the system uses that value as the file number of the 
SQLMSG file.
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 subsytem [nn]:
The default is Y.
N Display only the first error
Y Display all errors
B Display all errors but suppress the prefix:
N Display no warning messages
Y Display all warning messages
B Display all warnings but suppress the prefix:










