Ascential DataStage: Configure NLS Parameter For Using Oracle Database

To ensure that DataStage will take whatever character set from the sources and place them in the target database in the same character set, you need to set up the correct environment variables in the DataStage Engine. Following are the steps for the configuration:

1. Fine out what character sets that the source and target Oracle databases are using by queering the database:
--connect to the source Oracle database
-- run the following query:
SQL> SELECT * FROM V$NLS_PARAMETERS;
SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;
SQL> SELECT * FROM NLS_SESSION_PARAMETERS;
Note the parameter values for NLS_LANGUAGE, NLS_TERRITORY and NLS_CHARACTERSET.

2. Now check the dsenv file in the DataStage server. ( It is located in … /Ascential/DataStage/DSEngine/ directory.) In the dsenv file, find the line that has the Oracle NLS_LANG variable. It should look like:
NLS_LANG=<>_<>.<>
For example: NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG

3. Change or add this line as need. After you have edited the dsenv file, remember to stop and restart the server.

References:

• DataStage Documentations
• Other References On The Web

 Related Posts:

• Ascential DataStage: Linux Sendmail and Notification Activity
• Ascential DataStage: Routine to Reset Sequnce Key