Oracle NLS problem

[praburaj]

Hi,

When ever i read or write the data into the oracle 10G database
i am getting following warning

main_program: An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG

I tried changing the NLS map from the advanced tab of the oracle stage.its not allowing me to change because i am not finding the NLS
ICU codepage
How do i change it?
What should i do to rectify the warning?
Any inputs would be most appreciated

Thanks &Regards
Praburaj

[kumar_s]

Not in advance tab, but you should be able to find a seperate tab called NLS Map under the stage tab.
Make sure the project default map is selected over the list.

[ray.wurlod]

Just set the NLS_LANG environment variable appropriately.

[msarkar00]

I faced the same problem while reading the data from an oracle table could u pls tell me how u resolved the problem??

[ray.wurlod]

Are NLS_LANG and LANG_C environment variables correctly set?

[msarkar00]

Are NLS_LANG and LANG_C environment variables correctly set? ...

Where do is set them and what values should it contain..Pls send me some link if there is an info there already in the forum..I did nt find anything like that?

I am getting this err..
##W TDOR 000160 18:40:22(000) <main_program> An NLS map <-dboptions> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG
FATAL ERROR (APT_CharsetConverterRep::initConv()): -dboptions is not a valid codepage.

[ray.wurlod]

NLS_LANG is an environment variable that can be set in the executing user's .profile file, or in the dsenv script for DataStage processes.