Katz,
the display data mode has always been a bit troublesome and particularly so when working with multibyte data. You should write your data to a sequential file and view the data in the file. I have a suspicion that you settings are being interpreted correctly, but are being shown incorrectly in the designer.
NLS query
Moderators: chulett, rschirm, roy
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
To set an NLS_LANG environment variable for the job,
go to Job Properties, Parameters, click in Add Environment Variable, click on New, enter the variable name as NLS_LANG and enter a prompt.
Then you need to click on it (or possibly double click) to get it to appear in the paramter list (shows as $NLS_LANG) and then set the value to American_America.UTF8, or what ever be the NLS you want to set it to, which will be the default value at runtime.
You can make this as a Project Parameter and use it across all the mappings.
Hope this helps
go to Job Properties, Parameters, click in Add Environment Variable, click on New, enter the variable name as NLS_LANG and enter a prompt.
Then you need to click on it (or possibly double click) to get it to appear in the paramter list (shows as $NLS_LANG) and then set the value to American_America.UTF8, or what ever be the NLS you want to set it to, which will be the default value at runtime.
You can make this as a Project Parameter and use it across all the mappings.
Hope this helps