DSXchange

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.

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

Hi srinagesh,

Thanks for your suggestion. Does the NLS_LANG environment variable setting for the job simply override the default value as read from the DSENV file?

katz