Warning while using oracle stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 28
- Joined: Tue Aug 08, 2006 8:07 am
Warning while using oracle stage
Hello,
I am using oracle stage, I am using load. I am getting a warning when i run the job Warning:The NLS map <ISO-8859-1> specified may not be compatible with the character map specified in NLS_LANG. You may get unexpected results from your database.
So kindly help me where should i perform the changes in oracle or in datastage, and what all the changes i need to do.
Thanks & Regards,
Kalimuddin.
I am using oracle stage, I am using load. I am getting a warning when i run the job Warning:The NLS map <ISO-8859-1> specified may not be compatible with the character map specified in NLS_LANG. You may get unexpected results from your database.
So kindly help me where should i perform the changes in oracle or in datastage, and what all the changes i need to do.
Thanks & Regards,
Kalimuddin.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 28
- Joined: Tue Aug 08, 2006 8:07 am
-
- Participant
- Posts: 28
- Joined: Tue Aug 08, 2006 8:07 am
I have checked the NLS_LANG in oracle, Its AMERICAN. When I opened datastage Administrator, There by selecting the project I clicked on NLSray.wurlod wrote:What is the setting of NLS_LANG? ...
under the Project Locales the display of collate is off. just help me in setting that, because the NLS is not mapping.do kindly provide a solution for it.
Thanks & Regards,
Kalimuddin.
-
- Participant
- Posts: 28
- Joined: Tue Aug 08, 2006 8:07 am
-
- Participant
- Posts: 28
- Joined: Tue Aug 08, 2006 8:07 am
These are the PARAMETERS in ORACLE which I have.ArndW wrote:What is your Oracle NLS_CHARACTERSET? ...
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
-
- Participant
- Posts: 28
- Joined: Tue Aug 08, 2006 8:07 am
thumsup9 wrote:You can change your NLS settings in Job Properties window or within each stage for a job. Let us know whats your current setting in there.
The current setting is like this (as shown below).
Default map for stages is Project default (ISO-8859-1)
Default collation locale for stages is Project (OFF).
-
- Participant
- Posts: 7
- Joined: Wed Feb 08, 2006 2:34 am
Re: Warning while using oracle stage
If you have a character set includes data other than english, like arabic and other characters that come you cannot use this NLS LANG. You need to use the NLS_LANG as "Hexadecimal" I believe. I do not have access to DS to mention the exact value that NLS_LANG has to take here, but the way it works is you have to convert to hexa decimal character which can store all the characters. While retrieving such data you would have to set NLS LANG on the reporting tool to appropriate one that can display the data.kalimuddin wrote:Hello,
I am using oracle stage, I am using load. I am getting a warning when i run the job Warning:The NLS map <ISO-8859-1> specified may not be compatible with the character map specified in NLS_LANG. You may get unexpected results from your database.
So kindly help me where should i perform the changes in oracle or in datastage, and what all the changes i need to do.
Thanks & Regards,
Kalimuddin.
For ex: if you would have to display ARABIC data in excel from this DB which is in hexa decimal format, you would have to choose ARABIC character conversion set for data in excel.
-
- Participant
- Posts: 7
- Joined: Wed Feb 08, 2006 2:34 am
1) Further, I believe the DB installation that you have done does not support character sets other than English. This is what you had in NLS Settings:kalimuddin wrote:thumsup9 wrote:You can change your NLS settings in Job Properties window or within each stage for a job. Let us know whats your current setting in there.
The current setting is like this (as shown below).
Default map for stages is Project default (ISO-8859-1)
Default collation locale for stages is Project (OFF).
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
So, if you are using characters other than english in DB, you might have to do remove and install the DB that would support the NLS character set for all characters (other than english also)
2) Along with the DB installation, you would have to ensure that the DS server installation you do should support all characters. By default DS Server would install English character support. You need to include the locales that need to be supported while DS Server installation
-
- Participant
- Posts: 28
- Joined: Tue Aug 08, 2006 8:07 am
Re: Warning while using oracle stage
For testing I had created a job in which I have only the EMP_NO integer 38 null. The source is sequantial file, I had viewed the data and I can view it. I am using transformer, Here i am just mapping input to output. The target is Oracle stage,in that I am performing Write Method=LOAD, Write Mode=append. I have a table in oracle.when i am running it I am getting a 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 so here i am not using any arabic nor any other language. I am trying to load a number. When i checked my server locales every thing is in US-ENGLISH.
-
- Participant
- Posts: 7
- Joined: Wed Feb 08, 2006 2:34 am
Re: Warning while using oracle stage
Please check in the target stage(Oracle stage) in the Data Stage Job, that you are using is the NLS set to "None" or "ISO....". I believe that NLS could have been set to "None". It should be "ISO..." in the target Oracle DB stage in your jobkalimuddin wrote:For testing I had created a job in which I have only the EMP_NO integer 38 null. The source is sequantial file, I had viewed the data and I can view it. I am using transformer, Here i am just mapping input to output. The target is Oracle stage,in that I am performing Write Method=LOAD, Write Mode=append. I have a table in oracle.when i am running it I am getting a 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 so here i am not using any arabic nor any other language. I am trying to load a number. When i checked my server locales every thing is in US-ENGLISH.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not all of us are in your time zone. Some of us need to sleep. Have you searched the forum for all terms "Oracle" and "NLS"?kalimuddin wrote:can any one help me in resolving it.
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.