SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-6
SQLCA_DISPLAY2_
statistics optional input
PIC X
controls the display of statistics:
The default is Y.
caller-error-loc optional input
PIC X
controls the display of the program name and line number of the SQL statement
that received the error:
The default is Y.
internal-error-loc optional input
PIC X
controls the display of the system-code location where the first error in the SQLCA
occurred:
The default is Y.
prefix optional input
PIC X(length)
is a string that the program uses to precede each output line. The default is three
asterisks and a space (*** ).
prefix-length optional input
PIC S9(4) COMP
is the length of the prefix string for each output line. This length must be an
integer value from 1 to 15. If you include prefix, prefix-length is required.
Y Display row and cost statistics if the value returned to the SQLCA in the
ROW or COST field is greater than or equal to 0.
N Do not display statistics.
R Display row statistics only.
C Display cost statistics only.
Y Display the program name and line number.
N Suppress the display.
Y Display the location.
N Suppress the display.