Hi
I have problem to connect Oracle database.
I've created a simple job. I read data from sequential file and load into Ora DB.
During the processing I have errors:
"
main_program: 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."
Can you tell me what means this message?
I use DS EE on Windows.
Thanks,
Anka
NLS_LANG
Moderators: chulett, rschirm, roy
akrzy,
do you have a DBA that you can talk to? It is of paramount importance to understand the NLS settings on the DS side as well as on the Database side, and the NLS_LANG environment variable is very important in that.
Please look into the DataStage NLS Guide documentation; this will explain the settings and their implications.
The error message is quite explicit, you have different character set definitions in Oracle and in DataStage and although your single-byte characters will most certainly map you will have problems with the extended characters.[/b]
do you have a DBA that you can talk to? It is of paramount importance to understand the NLS settings on the DS side as well as on the Database side, and the NLS_LANG environment variable is very important in that.
Please look into the DataStage NLS Guide documentation; this will explain the settings and their implications.
The error message is quite explicit, you have different character set definitions in Oracle and in DataStage and although your single-byte characters will most certainly map you will have problems with the extended characters.[/b]
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
If you have installed DataStage with NLS enabled, then you need to add the user defined variable NLS_LANG to your DataStage environment (set to the same character map as the Oracle database).
You can find the Oracle setting for NLS_LANG by running the SQL:
You can find the Oracle setting for NLS_LANG by running the SQL:
Code: Select all
Select * from NLS_DATABASE_PARAMETERS