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 %ALLUSERSPROFILE%\Micro Focus\Enterprise Developer 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.