SQLCODE Error Values

SQL Communication Area › SQLCODE Error Values

SQLCODE Error Values

CA IDMS returns the following values in SQLCODE:

Value	Meaning
0	CA IDMS successfully executed the SQL statement.
>1	CA IDMS successfully executed the SQL statement but generated a warning in the process.
100	CA IDMS could find no row or no more rows to process.
-4	CA IDMS was unable to execute the SQL statement because errors were detected during processing. The transaction remains active.
-5	CA IDMS terminated the transaction abnormally to recover from a processing error. The session remains active unless it was automatically connected.
-6	CA IDMS has detected a condition that prevents further processing. The session is released.
-7	CA IDMS has detected an abnormal condition that prevents further processing. The SQL session is aborted.

SQLCODE and SQLCNRP Values

Result of bulk fetch	SQLCODE value	SQLCNRP value
No rows are returned	100	0
At least one row is returned but fewer rows than the maximum allowed	100	Equals the number of rows returned
The number of rows returned matches the maximum allowed	0	Equals the number of rows returned

Result of bulk select	SQLCODE value	SQLCNRP value
No rows are returned	100	0
At least one row is returned but fewer rows than the maximum allowed	100	Greater than 0 and less than or equal to the maximum allowed
The number of rows returned exceeds the maximum allowed	Less than 0	Equal to the maximum allowed

Result of bulk insert	SQLCODE value	SQLCNRP value
Fewer rows than the number of rows specified are inserted because the insert failed on a row	Less than 0	Equal to the relative row number of the failing row
The number of rows inserted matches the number of rows specified	0	Equal to the number of rows inserted

COBOL/CA ADS SQLCA

01 SQLCA. 02 SQLCAID PIC X(8). 02 SQLCODE PIC S9(9) COMP. 02 SQLCSID PIC X(8). 02 SQLCINFO. 03 SQLCERC PIC S9(9) COMP. 03 FILLER PIC S9(9) COMP. 03 SQLCNRP PIC S9(9) COMP. 03 FILLER PIC S9(9) COMP. 03 SQLCSER PIC S9(9) COMP. 03 FILLER PIC S9(9) COMP. 03 SQLCLNO PIC S9(9) COMP. 03 SQLCMCT PIC S9(9) COMP. 03 SQLCARC PIC S9(9) COMP. 03 SQLCFJB PIC S9(9) COMP. 03 FILLER PIC S9(9) COMP. 03 FILLER PIC S9(9) COMP. 02 SQLCINF2 REDEFINES SQLCINFO. 03 SQLERRD PIC S9(9) COMP OCCURS 12. 02 SQLCMSG. 03 SQLCERL PIC S9(9) COMP. 03 SQLERM PIC X(256). 02 SQLCMSG2 REDEFINES SQLCMSG. 03 FILLER PIC X(2). 03 SQLERRM. 04 SQLCERRML PIC S9(4) COMP. 04 SQLERRMC PIC X(256). 02 SQLSTATE PIC X(5). 02 SQLCRNF PIC X(1). 02 SQLCNRRS PIC S9(4) COMP. 02 FILLLER PIC X(8). ────┐ 02 SQLWORK PIC X(16). │ 02 SQLCWRK2 REDEFINES SQLWORK. │ 03 SQLERRP. │ 04 SQLCVAL PIC X(5). │ Included by the 04 FILLER PIC X(3). │ precompiler for 03 SQLWARN. │ DB2 compatibility; 04 SQLWARN0 PIC X(1). │ not used by CA IDMS 04 SQLWARN1 PIC X(1). │ 04 SQLWARN2 PIC X(1). │ 04 SQLWARN3 PIC X(1). │ 04 SQLWARN4 PIC X(1). │ 04 SQLWARN5 PIC X(1). │ 04 SQLWARN6 PIC X(1). │ 04 SQLWARN7 PIC X(1). │ ────┘

PL/I SQLCA

 DECLARE 1  SQLCA,
           2  SQLCAID          CHARACTER (8),
           2  SQLCODE          FIXED BINARY (31),
           2  SQLCSID          CHARACTER (8),
           2  SQLCINFO,
             3  SQLCERC        FIXED BINARY (31),
             3  FILLERnnnn     FIXED BINARY (31),
             3  SQLCNRP        FIXED BINARY (31),
             3  FILLERnnnn     FIXED BINARY (31),
             3  SQLCSER        FIXED BINARY (31),
             3  FILLERnnnn     FIXED BINARY (31),
             3  SQLCLNO        FIXED BINARY (31),
             3  SQLCMCT        FIXED BINARY (31),
             3  SQLCARC        FIXED BINARY (31),
             3  SQLCFJB        FIXED BINARY (31),
             3  FILLERnnnn     FIXED BINARY (31),
             3  FILLERnnnn     FIXED BINARY (31),
           2  SQLCMSG,
             3  SQLCERL        FIXED BINARY (31),
             3  SQLCERM        CHARACTER (256),
           2  SQLSTATE         CHARACTER (5),
           2  SQLCRNF          CHARACTER (1),
           2  SQLCNRRS         FIXED BINARY (15),
           2  FILLERnnnn       CHARACTER (8),
           2  SQLWORK          CHARACTER (16) ;

 DECLARE 1 SQLCINF2 BASED (ADDR(SQLCINFO)),
           2  SQLERRD   FIXED BINARY (31),

 DECLARE 1 SQLCMSG2 BASED(ADDR(SQLCMSG)),
           2  FILLERnnnn        CHARACTER (2),
           2  SQLERRM,
             3  SQLERRML        FIXED BINARY (15).
             3  SQLERRMC        CHARACTER (256) ;
                                          ────┐
 DECLARE 1 SQLCWRK2 BASED(ADDR(SQLWORK)),     │
           2  SQLERRP,                        │
             3  SQLCVAL        CHARACTER (5), │  Included by the
             3  FILLERnnnn     CHARACTER (3), │  precompiler for
           2  SQLWARN,                        │  DB2 compatibility;
             3  SQLWARN0  CHARACTER (1),      │  not used by CA IDMS.
             3  SQLWARN1  CHARACTER (1),      │
             3  SQLWARN2  CHARACTER (1),      │
             3  SQLWARN3  CHARACTER (1),      │
             3  SQLWARN4  CHARACTER (1),      │
             3  SQLWARN5  CHARACTER (1),      │
             3  SQLWARN6  CHARACTER (1),      │
             3  SQLWARN7  CHARACTER (1) ;     │
                                          ────┘