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