Different IBM® relational database products do not always produce the same SQLCODEs for similar errors. Even when the SQLCODE is the same, it might be accompanied by tokens that are specified differently. The token list is passed in the SQLERRMC field of the SQLCA. By default, DB2 Connect™ maps SQLCODEs and tokens from each host or System i™ database server to the appropriate DB2® SQLCODEs.
If you want to turn off SQLCODE mapping, specify NOMAP in the parameter string of the DCS directory.
If you port an application directly from a host or System i database server, such as DB2 Universal Database for OS/390® and z/OS®, you might want to turn off SQLCODE mapping. This would let you use the application without changing the SQLCODEs that it references.
Parent topic: DB2 Connect