SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-5
SQLCA_DISPLAY2_
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 length 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 the 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 multiple calls to the SQLCA_DISPLAY2_
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.
errors optional input
PIC X
controls the display of error messages:
The default is Y.
warnings optional input
PIC X
controls the display of warning messages:
The default is Y.
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]