To customize SQLCode mappings

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

Edit the mfhcocds.txt file

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

The mappings in the mfhcocds.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 mfhcocds.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.