SQL/MP Programming Manual for COBOL

SQL/MP System Procedures

HP NonStop SQL/MP Programming Manual for COBOL—529758-003

5-4

SQLCA_DISPLAY2_

The SQLCA_DISPLAY2_ procedure displays the error or warning messages that

SQL/MP returns to the SQLCA structure. SQLCA_DISPLAY2_ writes the information to

a file or to a terminal.

The information returned to the SQLCA structure can originate from these subsystems

or system components:



SQL/MP



NonStop OS



File system



Disk process (DP2)



FastSort program (SORTPROG process)



Sequential I/O (SIO) procedures

SQL/MP communicates errors, warnings, and statistics to a program through the

SQLCA structure. However, because the SQLCA contains information in a format that

is not appropriate to display, you must call the SQLCA_DISPLAY2_ procedure to

convert this information to an appropriate format.

sqlca required input

is the record name of the SQLCA structure.

output-file-number optional input

PIC S9(4) COMP

is the output file number. If you omit this value or set it to a negative value,

SQLCA_DISPLAY2_ displays information on your home terminal.

ENTER TAL "SQLCA_DISPLAY2_" USING

sqlca,

[ output-file-number, ]

[ output-record-length, ]

[ sql-msg-file-number, ]

[ errors, ]

[ warnings, ]

[ statistics, ]

[ caller-error-loc, ]

[ internal-error-loc, ]

[ prefix, ]

[ prefix-length, ]

[ suffix, ]

[ suffix-length ].