Unable to replace special characters in datastage 8.7 Versio
Posted: Sat Dec 13, 2014 10:39 pm
Hi,
In datastage 7.5 version installed on windows there are special characters or may be they are unicode representations whiich are like
"..:" "-" "-->".
In 7.5 server jobs the above characters are replaced using rreplace function of char(9) char(10).Char(13) char(26).
when i tried to replicate the same derivation in 8.7 parallel jobs the symbols are not getting replaced instead the alphabets are getting replaced.
Tried to print the characters in datastage using Char function but was not possible.
i think the char function will only take a decimal input and not hexadecimal input.
Is there any environmental variable to handle this.
request your suggestions on how to handle this scenario.
In datastage 7.5 version installed on windows there are special characters or may be they are unicode representations whiich are like
"..:" "-" "-->".
In 7.5 server jobs the above characters are replaced using rreplace function of char(9) char(10).Char(13) char(26).
when i tried to replicate the same derivation in 8.7 parallel jobs the symbols are not getting replaced instead the alphabets are getting replaced.
Tried to print the characters in datastage using Char function but was not possible.
i think the char function will only take a decimal input and not hexadecimal input.
Is there any environmental variable to handle this.
request your suggestions on how to handle this scenario.