DSXchange

Use the correct UniChar() function to describe the characters.

ray.wurlod wrote:Use the correct UniChar() function to describe the characters. ...

UniChar() function does not work in Transformer, Could you please let me know how exactly do I need to use UniChar() exactly for this particular example.

appreciate your kind support

What do you mean by "doesn't work"?

Do you have NLS installed and enabled?

If not, you will struggle to process accented characters, etc.

Oh Ok.

The NLS is not been installed. and its not possible to install it now.

Now the work around would be DS Routines or unix script.

Is there any other way of doing it without NLS istalled, please suggest.

Can anybody please tell me what is NLS?
And how to check whether it is installed or not in a system?

You can use the tr command in a wrapper stage. for the column.

But for this you need to know the ASCII valuer of the special character.

Bicchu wrote:Can anybody please tell me what is NLS?
And how to check whether it is installed or not in a system?

You can check the NLSMODE setting in the uvconfig file. If NLSMODE is 0 then NLS has not been installed. As to what it is, Google is your friend.

NLS is "National Language Support" - a misnomer because it's about character sets and locales, not about languages. NLS provides the means to map external character sets (for example SHIFT-JIS for Japanese) into the Unicode used within DataStage.

Actually, if NLSMODE is 0, then NLS has been installed but not enabled.

If NLS has not been installed, NLSMODE does not even appear in uvconfig.

D'oh! For some reason when I transcribed a post I found on the subject, I ended up typing 'installed' when it said 'activated'.