SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-31
SQLCADISPLAY
output-record-length optional input
PIC S9(4) COMP
is the length in bytes of records to be written to the output file. The length must be
an integer value from 60 to 600.
The default is 79 bytes.
sql-msg-file-number optional input/output
PIC S9(4) COMP
is the file number of the SQL message file (SQLMSG is the default file). If you
specify -1 as an input value, the system opens the message file and returns the
resulting file number. If you specify a value other than -1, the system uses that
value as the file number of the message file.
To improve the performance of a program that makes multiple calls to the
SQLCADISPLAY procedure, specify -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.
The SQLMSG file contains text in English. You can specify a different SQL
message file with the =_SQL_MSG_system DEFINE. For more information, see
SQL Message File on page 5-2.
errors optional input
PIC S9(4) COMP
controls the display of error messages to the buffer:
The default is Y.
warnings optional input
PIC S9(4) COMP
controls the display of warning messages to the buffer:
Y Display all errors.
N Display only the first error.
B Display all errors but suppress this prefix:
ERROR from subsystem [nn]:
Y Display all warning messages.
N Do not display any warning messages.
B Display all warnings but suppress this prefix:
WARNING from subsystem [nn]