From the Customize SQLCode Mappings tool, click the
SQLCode Mappings tab. HCOSS loads the SQLCode mappings found in the
mfhcocds.txt file.
To restore previous mappings from a backup file, click
Restore (optional).
To change the mappings, click any field on the grid and type in a new value. All values must be in valid SQLCode or SQLState
value format.
To add a new mapping, click the blank row at the bottom of the grid and type in a new value for each column.
Note: Each time you click a field in the blank bottom row, a new blank row appears underneath to enable you to add another new mapping.
To save your changes to the
mfhcocds.txt file and create a backup file with the initial mappings, click
Save.
To deploy the changes to your SQL Server database (required when using SQL CLR stored procedures), click
Deploy. This takes you to the
Deploy / Extract tab.
From the
Data Source Name drop-down list, select the data source you want to update with the new mappings.
Complete the
User ID and
Password fields only if required by your data source.
Click
Deploy to SS.
To extract the SQLCode mapping information from the SQL Server database to a backup file, click
Extract from SS (optional).