Problem Summary: DB2 for i binary columns (CCSID encoded) to MSSQL varchar
Customer tried to setup a ColumnProperties action to translate binary fields from DB2i that are stored as binary encoded text (CCSID 37, US English). The following configuration is partially successful:
/DatatypeMatch=binary /Datatype=varchar /Length=bytelen
Unfortunately the text encoding is missed and the target characters do not match our source. How do you specify an encoding for a binary field at the source, or for translation during integrate?
Answer:
Assuming you are on a recent version of HVR then you should set the following environment variable on the source:
HVR_DB_CHARSET_BITDATA, with a value of "IBM037"
After this action is added channel should be initialized with 'Scripts and Jobs' option