does Datastage Handle ascii extended chars
Posted: Sat Jun 30, 2007 2:35 pm
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.
A short text to describe your forum
http://dsxchange.com./
Code: Select all
we are receiving international data
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 laterrafik2k wrote:Is there any spceail charachter set you are receiving?Code: Select all
we are receiving international data
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)