SQLCODE (XDB Mode)

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.ERR
-651 to -2000 Database Engine Error Take absolute value, subtract 1000, prefix with "X" XDBRES.ERR
-2001 to -3000 Network Error Take absolute value, subtract 1650, prefix with "N" XDBNET.ERR
-3001 to -3999 Not used. -- --
-4000 to -4,100 Distributed DBMS Communication Error Take absolute value and prefix with "L". XDBMF.ERR