Replicate DB2 TABLE EBCDIC data to SQL TABLE - ASIS (MIRROR Image, no data transformation)

[ravirao68]

We want to do CDC from source IBM DB2 to target Microsoft SQL Server.  My queries are as follows:

a. Is it possible to copy IBM DB2 EBCDIC table data to be copied ASIS (i.e. MIRROR Image, no data transformation) to Microsoft SQL Server.?  We are using Collate SQL_EBCDIC037_CP1_CS_AS for char() and varchar() fields to store the EBCDIC data in the Microsoft SQL Table.

b. In the current CDC process, we see that IBM DB2 char() datatype is converted to varchar() in the Microsoft SQL Server - how can we retain the char() datatype in Microsoft SQL Server?

Could you please provide some solution to the above.

[ravirao68 · Accepted solution]

Thanks John for your inputs.  We will open a support ticket for furether assistance.