SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-17
SQLCATOBUFFER
caller-error-loc input
CHAR
controls the writing of the program name and line number of the SQL
statement that received the error. The values the program can specify and their
meanings are:
The default is Y.
internal-error-loc input
CHAR
controls the writing of the location in system code where the first error in the
SQLCA occurred. The values the program 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, null is the default.
Guidelines
•
NonStop SQL returns errors as negative numbers and warnings as positive
numbers.
•
If there is no text for an error number, NonStop SQL displays:
No error text found.
•
The $SYSTEM.SYSTEM.SQLMSG file contains the error text for SQL messages.
If you receive this message appears, your version of the SQLMSG file might not
match the version of the SQL executor.
Y Enable writing the information
N Suppress writing the information
Y Enable writing the information
N Suppress writing the information