Hi All,
My source stage is Oracle enterprise. When I try to view data iam getting the following message:
The NLS character map <windows-1252> is specified, but NLS_LANG is not set;
the NLS character map must be set to an ICU codepage which is equivalent to
the character set specified by NLS_LANG.
By default are the following options:
Category to set map for : NCHAR\NVARCHAR2
Map Name: windows-1252
Could some one please suggest the solution.
Best Regards
Cherry
NLS_LANG Not set
Moderators: chulett, rschirm, roy
NLS_LANG is an environment variable that Oracle uses at runtime. This, along with ORACLE_SID and ORACLE_HOME should be set (either directly or through oracle script calls) in your dsenv script file. If it is missing then you need to correct that.
The NLS_LANG setting should be determined by your Oracle database settings, not those of DataStage. Talk to your Oracle DBA in order to find out the correct setting. An example, taken from my current machine, would look like "NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1"
The NLS_LANG setting should be determined by your Oracle database settings, not those of DataStage. Talk to your Oracle DBA in order to find out the correct setting. An example, taken from my current machine, would look like "NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
On Windows NLS_LANG needs to be set, with other environment variables, via Control Panel on the server. Windows implementation of DataStage does not use a dsenv script.
Apart from that, what Arnd advised is correct.
Apart from that, what Arnd advised is correct.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.