SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-5
SQLCADISPLAY
caller^error^loc input
INT
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:
Y Enable the display of the information.
N Suppress the display of the information.
The default is Y.
internal^error^loc input
INT
controls displaying the location in system code where the first error in the SQLCA
structure occurred. The values you can specify and their meanings are:
Y Enable the display of the information.
N Suppress the display of the information.
The default is Y.
prefix input
STRING .EXT
specifies a string that the program uses to precede each output line.
The default is three asterisks and a space (*** ).
prefix^len input
INT
specifies the length of the prefix string to precede each output line. The length can
be an integer value from 1 through 15. If you include the prefix parameter, you
must also include this parameter. If you omit the prefix parameter, you must also
omit this parameter.
suffix input
STRING .EXT
specifies a string to be appended to each output line.
The default is a null string.