DB2 for i binary columns (CCSID encoded) to MSSQL varchar

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #20219
    James Daily

    I have tried to setup a ColumnProperties action to translate binary fields from DB2 for i 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?


    Hi James,

    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”

    I recommend you do this through an action Environment.

    Hope this helps.


    James Daily

    That worked, thank you.

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us