Created On:  18 October 2010

Problem:

Where can I find descriptions of SQLCODE values for XDB?

Resolution:

Below is a breakdown of how the XDB errors can be converted into SQL codes and vice-versa:

Error Type    Error File

  -----------   -------------

     L             XDBMF.ERR      DB2 ERRORS (OFFSET BY 3000)

     X            XDBRES.ERR

     N            XDBNET.ERR      OFFSET BY 650

     SC         XDBSRVCO.ERR

 

     COBOL:     XDB errors begin at -1000

        USE THIS FOR RPC ERROR DECODING

        eg. -1352 = x352  XDB error  <>
 

        XDBNET errors start at -1650 (1000 650)

        eg. -1654 = N4  Network error  <>
 

        DB2 error start at -3000

        eg. -3911 = -911 DB2 error     <>
 

        eg. -2058 = 2058 - 1000 - 650 = N408

            -2059 = 2059 - 1000 - 650 = N409

            -2060 = 2060 - 1000 - 650 = N410

              - Password failure

              - DB2-CICS interface down