SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-5
SQLCADISPLAY
statistics input
CHAR
controls the writing of statistics. The values you can specify and their meanings
are:
The default is Y.
caller-error-loc input
CHAR
controls displaying the program name and line number of the SQL statement
that received the error. The values you can specify and their meanings are:
The default is Y.
internal-error-loc input
CHAR
controls displaying the location in system code where the first error in the
SQLCA occurred. The values you can specify and their meanings are:
The default is Y.
prefix input
FSTRING
specifies a string to prefix each output line. The default is three stars and a
blank (*** ).
suffix input
FSTRING
specifies a string to be appended to each output line. If the call statement omits
this string, the default is a null string.
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
R Display rows only
C Display cost only
N Display no statistics
Y Enable displaying the information
N Suppress displaying the information
Y Enable displaying the information
N Suppress displaying the information