HCOSS automatically maps OpenESQL SQLCode values to their equivalent DB2 SQLCode and SQLState values using the information defined in the mfhcocds.txt file. HCOSS comes with standard default SQLCode mappings. You can customize these mappings by directly editing the mfhcocds.txt file.
You can use any text editor to make changes to default settings or to add SQLCode mappings stored in the mfhcocds.txt file. The mappings are stored in a comma-delimited format with each line listing an OpenESQL SQLCode value followed by its DB2 SQLCode value equivalent followed by the SQLState value returned for the OpenESQL SQLCode value. For example, here is a listing of the default mfhcocds.txt contents:
* 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