To customize SQLCode mappings

HCOPG provides two methods you can use to customize SQL Code mappings. They are:

Edit the mfhcocds_PG.txt file
The default method is to use a text editor to modify the OpenESQL SQLCode mappings file, mfhcocds_PG.txt, located in the $COBDIR/etc folder.

The mappings in the mfcocds_PG.txt file are stored in a comma-delimited format. Each row lists an OpenESQL SQLCode value followed by its DB2 SQLCode value equivalent followed by the SQLState value returned for the OpenESQL SQLCode value. The following is an example mfcocds_PG.txt file: 

* OESQL SQLCODE, DB2 SQLCODE, DB2 SQLSTATE DELIMITED BY COMMAS
-2601,-803,23505
-19519,-501,24501
-19516,-502,24502
-2714,-601,42710
-207,-204,42704
-208,-204,42704
Use the SQL Error Mapping feature
You can use the OpenESQL SQL Error Mapping feature. For details, see SQL Error Mapping.
Parent topic: How to
Related concepts
SQL Error Mapping