The following table describes the SQLCODE values when you are running in XDB mode.
SQLCODE is an element of SQLCA that stores the error code returned by an SQL process. If you are running in XDB mode, the value in SQLCODE is expressed as XDB error code. To determine the appropriate error code, you must translate it into an XDB error message ID using the formula listed in the table below.
| SQLCODE Value | Error Type | Formula | Msg File |
|---|---|---|---|
| -1 to -650 | Remote DBMS Error | Take absolute value and prefix with "L". | XDBMF.XRR |
| -651 to -2000 | Database Engine Error | Take absolute value, subtract 1000, prefix with "X" | XDBRES.XRR |
| -2001 to -3000 | Network Error | Take absolute value, subtract 1650, prefix with "N" | XDBNET.XRR |
| -3001 to -3999 | Not used. | -- | -- |
| -4000 to -4,100 | Distributed DBMS Communication Error | Take absolute value and prefix with "L". | XDBMF.XRR |