Customizing Functions and Special Registers

HCOSS converts DB2 functions and special registers to SQL Server functions or special registers automatically, using a set of defaults to map each DB2 function or special register to a corresponding SQL Server function or special register.

If you want to convert any of your DB2 database functions or special registers to SQL Server database functions or special registers using settings other than the defaults mapped by HCOSS, you can customize them.

From the HCOSS Customize SQL Name Mappings tool, you can customize the following for each DB2 function or special register:

The SQL Server equivalent
Whether SQL Server handles it as a function or a special register

Also from the Custom SQL Name Mappings tool, you can add DB2 functions and special registers defined in your DB2 database that are not represented in your SQL Server database.

Important: If you want to add a mapping for a DB2 function or special register that exists in your DB2 database but that is not represented in your SQL Server database, you must first create the SQL Server object in your SQL Server database. All objects must be present in the SQL Server database before you can create the mapping, and before you bind your application.