NLS_LANG not populating from DSENV

rosecity · Post by **rosecity** » Wed Aug 14, 2013 1:45 pm

Hi,
We have 2 different datastage projects in the same server.
NLS_LANG is set as an Environment Variable in Administrator under both projects.. The initial value is left blank.
NLS_LANG is also defined, with a value, in the DSENV file. (and my understanding is that the same DSENV applies to both projects since they are built on the same server)

The problem is, when a Parallel job is run, the value for NLS_LANG appears in the director logs under one project but remains blank in the other one. (like NLS_LANG = )

Explicitly providing a value in either the Administrator or adding this Env Variable in the parameters and giving it a value there do help show the value in the Director... but we are trying to understand if these 2 projects are set up differently.

Could there be some other setting that is causing this Env variable to show as blank instead of getting its value from dsenv?

ArndW · Post by **ArndW** » Thu Aug 15, 2013 1:25 am

While the DSENV file is common to all projects, each project has a DSPARAMS file and you might be setting the parameter in one but not the other. Check each project using your DataStage administrator program to see if this might be the problem.

rosecity · Post by **rosecity** » Fri Aug 16, 2013 1:32 pm

Checked that too, but they are both setup alike.

For now, we got around by removing the Env Variable entry from the Administrator... this helped it get the NLS_LANG value from the DSENV file.
Thanks for reading and sharing your thoughts.