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
.
After this action is added, the channel should be initialized with the Scripts and Jobs option enabled.