Warning while using oracle stage

kalimuddin · Post by **kalimuddin** » Mon Sep 04, 2006 11:55 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 05, 2006 4:26 am

What is the setting of NLS_LANG?

kalimuddin · Post by **kalimuddin** » Tue Sep 05, 2006 7:17 am

ray.wurlod wrote:What is the setting of NLS_LANG? ...

Its in oracle. I have changed the NLS DATE FORMAT but I dont know how to set this NLS LANG. It is the language setting.

kalimuddin · Post by **kalimuddin** » Tue Sep 05, 2006 11:21 am

ray.wurlod wrote:What is the setting of NLS_LANG? ...

I have checked the NLS_LANG in oracle, Its AMERICAN. When I opened datastage Administrator, There by selecting the project I clicked on NLS
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.

kalimuddin · Post by **kalimuddin** » Wed Sep 06, 2006 7:35 am

can any one help me in resolving it.

thumsup9 · Post by **thumsup9** » Wed Sep 06, 2006 7:50 am

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.

ArndW · Post by **ArndW** » Wed Sep 06, 2006 7:56 am

What is your Oracle NLS_CHARACTERSET?

meena · Post by **meena** » Wed Sep 06, 2006 7:58 am

Hi
Check for NLS_LANG in your dsenv and it should have the same value as in database. And also do a search on "The NLS map <ISO-8859-1> specified" with search all terms option. There are few posts discussed on this.

kalimuddin · Post by **kalimuddin** » Wed Sep 06, 2006 8:07 am

ArndW wrote:What is your Oracle NLS_CHARACTERSET? ...

These are the PARAMETERS in ORACLE which I have.

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

kalimuddin · Post by **kalimuddin** » Wed Sep 06, 2006 8:15 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).

gootala_ravi · Post by **gootala_ravi** » Wed Sep 06, 2006 8:40 am

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.

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.

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.

gootala_ravi · Post by **gootala_ravi** » Wed Sep 06, 2006 8:45 am

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).

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:

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

kalimuddin · Post by **kalimuddin** » Wed Sep 06, 2006 9:03 am

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.

gootala_ravi · Post by **gootala_ravi** » Wed Sep 06, 2006 9:10 am

kalimuddin 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.

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 job

ray.wurlod · Post by **ray.wurlod** » Wed Sep 06, 2006 4:22 pm

kalimuddin wrote:can any one help me in resolving it.

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"?

DSXchange

Warning while using oracle stage

Warning while using oracle stage

Re: Warning while using oracle stage

Re: Warning while using oracle stage

Re: Warning while using oracle stage