The following apply to HCOSS DB2 to SQL Server conversion:
- Converts DB2 functions and special registers to SQL Server functions and special registers according to a set of the defaults that best match one to the other. Customizable.
- Converts DB2 data types to SQL Server data types according to a set of defaults that best match one to the other. Customizable.
- Converts DB2 SQLCODE values to equivalent SQL Server SQLCODE values. Customizable.
- Optimization of DB2 SQL statements is allowed and done by adding SQL Server query hints, such as OPTION(RECOMPILE), to select, insert, update, and delete statements.
- Concatenation of SQL Server SQL TYPE BINARY and SQL TYPE VARBINARY data according to DB2 rules is done via the CONCAT_BINARY function and operator.
- Applications that concatenate z/OS DB2 BINARY or VARBINARY values to use CONCAT_BINARY must be manually converted when migrating to SQL Server.
- CONCAT_BINARY is converted to the HCOSS-supplied dbo.CONCAT_BINARY call.
- For SQL Server 2012 SP2 and later, DECLARE GLOBAL TEMPORARY statements support:
- SQL(CHECK), at compile time
- Both AS and LIKE clauses, in addition to column definition specifications
To learn more about changing HCOSS default settings for DB2 functions and special registers, data types, SQLCODE values and SQL identifiers, see
Customizing HCOSS. To review HCOSS default settings and additional support information for these items, see
DB2 to SQL Server Conversion Reference.
