SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-32
SQLCADISPLAY
The default is Y.
statistics optional input
PIC S9(4) COMP
controls the display of statistics:
The default is Y.
caller-error-loc optional input
PIC S9(4) COMP
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 S9(4) COMP
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 to precede each output line. The default is three asterisks and a space
(*** ).
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 information.