How to Specify Encoding for Binary Field

Issue

How do you specify an encoding for a binary field at the source, or for translation during integrate?

For translating DB2 for i binary columns (CCSID encoded) to MSSQL varchar, customer tried to set up a ColumnProperties action to translate binary fields from DB2 for i that are stored as binary encoded text (CCSID 37, US English) through the following configuration which is partially successful:

/DatatypeMatch=binary /Datatype=varchar /Length=bytelen

However, the text encoding is missed and the target characters do not match the source.

Environment

HVR

Resolution

On the source, set environment variable HVR_DB_CHARSET_BITDATA with a value of IBM037.

Specify encoding

After this action is added, the channel should be initialized with the Scripts and Jobs option enabled.