NLS Warning message

[dsuser_cai]

Hi

I know this is common, question but i couldnt understand this issue.

I get this warning message in all my jobs (only in paralle), im using the same DS to build server jobs but that didesbt have warnings. but paralle jobs always gives out this message:

warning message:

main_program: The NLS character map <ISO-8859-1> specified may not be compatible with
the character set specified by NLS_LANG;
you may get unexpected results from your database.

main_program: The NLS character map <ISO-8859-1> specified may not be compatible with the character set specified by NLS_LANG;
you may get unexpected results from your database.

Can somebody help me fix this........

[chulett]

And "the character set specified by NLS_LANG" is.... ?

[dsuser_cai]

And "the character set specified by NLS_LANG" is.... ?

I checked the NLS settin in my database (SELECT * FROM NLS_SESSION_PARAMETERS) and its NLSLANGUAGE -----> AMERICAN

but Im not sure how to check the NLS in DS.

I checked in the oracle stage and it has the following defined in the NLS tab:

Select category to set map for:
NCHAR / NVARCHAR2

Map Name for NCHAR / NVARCHAR2
Project default (ISO-8859-1)

Please let me know if my setting wrong or im looking at the wrong stage/tab. also please let me know if u need further information.

[chulett]

The second log entry for any job shows all environment variables in place at the time the job ran - what does it show there for NLS_LANG?

[dsuser_cai]

The second log entry for any job shows all environment variables in place at the time the job ran - what does it show there for NLS_LANG?

thanks for helping me find this.

I check that log entry and it shows:

NLS_LANG=AMERICAN_AMERICA.US7ASCII

is this correct ?

[dsuser_cai]

I still have this warning message, Can anybody help me fix this. I recently heard that there is an Environmental variable used to fix this warning message. If known can anybody share it with me. Thanks in advance.