Character  converted to A
Moderators: chulett, rschirm, roy
Debug it by checking the value of that string at each stage of the process to discover which component seems to be doing the modification.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
The DataStage "View Data" facility has caused more perceived NLS problems than any other part of the tool - it is not capable of correctly displaying NLS data and shouldn't be used to see if NLS is working or not. Did you "view data" to see the character or use another tools?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
When you read from Oracle into DataStage you need to specify the correct NLS map - the one Oracle is actually using. The same needs to be done when writing to your target. If either one of these settings is not done correctly then it is possible that characters don't get mapped the way you expect.
What are your Oracle source settings?
What are your Oracle source settings?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi,
We have checked the NLS settings for source and target database and these are the same.
Therefore, the issue seems to be with DS NLS settings itself.
We have asked the Admin to provide details of the NLS setup as these are not accesible to us.
Will post them as and when we get updates.
We have checked the NLS settings for source and target database and these are the same.
Therefore, the issue seems to be with DS NLS settings itself.
We have asked the Admin to provide details of the NLS setup as these are not accesible to us.
Will post them as and when we get updates.
Regards,
Bakul
Bakul
you should have read access to this file.ArndW wrote:Do you have NLS settings in your $DSHOME/uvconfig file? If not, then NLS is not enabled.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
That parameter doesn't have to do with NLS; if your uvconfig has no NLS entries then any character conversion is not being done by DataStage. Read your Oracle and write to a text file, then look at the value in the text file (not with View Data in DataStage) to see if has been altered. What is your NLS_LANG environment setting?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>