DSXchange

Hi experts,

While loading special characters in netezza database, box character is inserted after one of special character Atilde (~ on top of A).

but when checking updating the netezza database directly, it is working fine. No such box character.

Problem is in Datastage 8.1, Is there any environmental setup to done to avoid this junk character?

Is there any other way of avoiding the junk character?

Thanks in advance

When using Basic transformer, I got this warning

Invalid character(s) ([xC6]) found converting string (code point(s): [xC6][xE8]) from codepage UTF-8 to Unicode, substituting.

trying to do Ereplace but it is also not working Ereplace(col.name, char(198),char(20))

hi raju ,
APT_STRING_PADCHAR. I usually set its value to 0*20 (space).and trim space if necessary ,thus keeping my string clean

FYI - 0x20 is a space.