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

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

    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?

    #20227
    Mark
    Keymaster

    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.

    Mark.

    #20228
    James Daily
    Participant

    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