Results 1 to 2 of 2

Thread: Character Substitution for source IBM DB2 for iSeries using Replicate

  1. #1
    pruviv00 is offline Junior Member
    Join Date
    Dec 2019
    Posts
    1
    Rep Power
    0

    Question Character Substitution for source IBM DB2 for iSeries using Replicate

    Hi,

    I am trying to Delete Source Character (which is in unreadable format) using Character Substitution option available in Replicate Setting white loading the data, i am trying to use character set as "ebcdic-xml-us" and Substitute Character as "U+0".
    But this is not working i still see lot the unreadable characters are ingesting in.
    Could any one please help me identify the correct character for DB2 iSeries (AS400) to replace.

  2. #2
    Hein is offline Senior Member
    Join Date
    Dec 2007
    Location
    Nashua, NH - USA.
    Posts
    165
    Rep Power
    13
    What is the target endpoint?

    Most targets support an 'internal parameter' under 'advanced settings' called :
    replaceChars
    Example usage to replace Carriage-Return and Line-Feed each with a 'space': "replaceChars": "0x0D,0x20,0x0a,0x20"
    Some endpoints, notably Snowflake, have
    replaceInvalidChars
    This affects all tables all columns on the target. Maybe you can find a solution in that direction?

    Hein


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •