How to convert special character in Datastage Transformer

ray.wurlod · Post by **ray.wurlod** » Tue May 17, 2011 3:22 pm

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

Md Dawar Mughni · Post by **Md Dawar Mughni** » Wed May 18, 2011 4:44 am

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

ray.wurlod · Post by **ray.wurlod** » Wed May 18, 2011 5:48 pm

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.

Md Dawar Mughni · Post by **Md Dawar Mughni** » Thu Jun 02, 2011 3:12 am

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.

Bicchu · Post by **Bicchu** » Wed Jun 08, 2011 3:56 am

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

samyamkrishna · Post by **samyamkrishna** » Wed Jun 08, 2011 4:02 am

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.

chulett · Post by **chulett** » Wed Jun 08, 2011 6:18 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 08, 2011 4:34 pm

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.

chulett · Post by **chulett** » Wed Jun 08, 2011 7:58 pm

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