Customize SQLCode Mappings Tool

HCOSS stores OpenESQL SQLCodes and their DB2 SQLCode and DB2 SQLState equivalents. This information, called SQLCode mappings, is stored both in your SQL Server database and in a flat text file named mfhcocds.txt. You can use the Customize SQLCode Mappings tool to manage the information in the mfhcocds.txt file and the SQL Server database.

The Customize SQLCode Mappings tool provides the following functionality:

By default, loads the SQLCode mappings found in mfhcocds.txt.
Enables you to make changes to existing mappings and add new mappings.
Each time you save changes, creates a backup file containing mapping information, using the following naming convention:
mfhcocds_backup_dateTime.txt
Restores previous mappings by reloading a backup file.
Deploys mapping changes to your SQL Server database.
Extracts SQLCode mappings stored in the SQL Server database to a backup file.

HCOSS stores the mfhcocds.txt file and its backup files in your %ALLUSERSPROFILE%\Micro Focus\Enterprise Developer directory.

Important: If you use HCOSS with SQL CLR stored procedures and you want to deploy to the SQL Server database from a machine other than your development machine, you must install HCOSS on that machine, and then copy your most recent mfhcocds.txt file to the %ALLUSERSPROFILE%\Micro Focus\Enterprise Developer directory on the same machine.

You can also use any text editor to make changes to 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