Page 1 of 1

does Datastage Handle ascii extended chars

Posted: Sat Jun 30, 2007 2:35 pm
by muascdev
we are receiving international data, and i want to know if dataset handles it or not, if yes what do we need to do so DS handles it.

Posted: Sat Jun 30, 2007 2:58 pm
by ray.wurlod
DataStage handles every character that can be encountered in business data processing in all known data sets.

Without knowing precisely what you mean by "ASCII extended" it's not really possible to indicate whether there's anything you need to do or not.

Posted: Sat Jun 30, 2007 3:07 pm
by rafik2k

Code: Select all

we are receiving international data
Is there any spceail charachter set you are receiving?

You need to check for your project's NLS map and collation locale setting.

If you get any error due to unhandling of special character while running job, then you need to set appropriate setting for your project to handle these chars.

You can set NLS map at project level, at job level and also at stage level(not all stage support it)

Posted: Sun Jul 01, 2007 7:15 am
by vijayrc
rafik2k wrote:

Code: Select all

we are receiving international data
Is there any spceail charachter set you are receiving?

You need to check for your project's NLS map and collation locale setting.

If you get any error due to unhandling of special character while running job, then you need to set appropriate setting for your project to handle these chars.

You can set NLS map at project level, at job level and also at stage level(not all stage support it)
We have few special characters coming in, and changing IBM500 to IBM700 in administarator for one of the Options did the trick..Dont remember, as I am not connected, but give a try or I'll post it later