DB2 to Datastage Special Character Issue

ArndW · Post by **ArndW** » Thu Jul 24, 2008 9:40 am

do you have DataStage with NLS installed?

rajkraj · Post by **rajkraj** » Thu Jul 24, 2008 9:46 am

Nope, NLS not installed

Without installing NLS is there any way we can handle this situation?

ArndW · Post by **ArndW** » Thu Jul 24, 2008 10:05 am

In this case it might be easier, since the conversion is only happening in one place. What character set is your DB2 set to?

ray.wurlod · Post by **ray.wurlod** » Thu Jul 24, 2008 3:20 pm

If you know what the code point for the character is you can intercept it with a Char() function perhaps in a Convert() function.