SQL/MP Programming Manual for COBOL

Error and Status Reporting
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
9-14
Returning Information From the SQLCA
SQL-ERROR Repeating group for error information. There are 7
occurrences, each of which returns information for a single
error or warning.
ERRCODE Error and warning messages are documented in the
SQL/MP Messages Manual.
SUBSYSTEM-ID One-byte code that identifies the system component
issuing the error or warning:
D DP2 disk process
F SQL file system
G NonStop OS
I Sequential I/O (SIO) procedures
L Load routines
S SQL/MP component: (SQL compiler, catalog manager,
executor, SQLUTIL, SQLCI, SQLCI2)
R SORTPROG process (FastSort program)
SUPPRESS-DISPLAY Code that indicates whether to suppress the display. The
system component issuing the message sets this data item
to Y (for yes) to suppress the display, or to N (for no) to
display the item ERRCODE and the text of the error
message. If the component does not set the item, the
default is N.
PARAMS-OFFSET Offset in item PARAMS-BUFFER for the parameters of the
error or warning message. The value is -1 if
PARAMS-COUNT equals 0.
PARAMS-COUNT Number of parameters returned for the error or warning
message.
ARRIVAL-SEQ Sequence in which the error was set. The value is set to -1
when the SQLCA is initialized. For internal use only.
SQLCODEA Redefinition of ERRORS-ALL.
SQLCODE First error or warning code. SQLCODE redefines
ERRCODE (1). Use this data item to test if errors or
warnings occur. Use the SQLCA_DISPLAY2_,
SQLCA_TOBUFFER2_, and SQLCAFSCODE procedures
to obtain detailed information.
Table 9-1. SQLCA Structure Fields (page 2 of 3)
Field Name Description