SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-36
SQLCATOBUFFER
The procedure pads each line with spaces and adds the suffix and prefix strings if
the ENTER statement specifies them.
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.
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 writing of error messages to the buffer:
The default is Y.
warnings optional input
PIC S9(4) COMP
controls the writing of warning messages to the buffer:
The default is Y.
Y Write all errors.
N Write only the first error.
B Write all errors but suppress this prefix:
ERROR from subsystem [nn]:
Y Write all warning messages.
N Do not write any warning messages.
B Write all warnings but suppress this prefix:
WARNING from subsystem [nn]