Restriction: This topic applies to Windows environments only.
- 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).