SQLCODE mapping

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 IBM mainframe 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 IBM mainframe database server, such as Db2 for z/OS, you might want to turn off SQLCODE mapping. This would let you use the application without changing the SQLCODEs that it references.