Oracle NLS_NUMERIC_CHARACTERS setting in Datastage 8.5

coface · Post by **coface** » Tue May 31, 2011 1:25 am

I have a Datastage 8.5 Server that needs to communicate with an Oracle database. If I want to retrieve a decimal value in a query, Datastage set a dot or a comma behind it.

the equivalent setting in the Database is NLS_NUMERIC_CHARACTERS=,. that i can set in the enviroment settings. The orchdbutil not interested on this setting and I get on startup of the tool always the wrong NLS_NUMERIC_CHARACTERS=., displayed.

How i can convince Datastage to set NLS_NUMERIC_CHARACTERS=,. for the session?

Change the Setting in the Job is no option, to many Jobs!

chulett · Post by **chulett** » Tue May 31, 2011 6:40 am

Will it hurt to set it for all jobs? If not, then add that environment variable to your dsenv file.

ray.wurlod · Post by **ray.wurlod** » Tue May 31, 2011 6:46 am

Or set it for just that project by creating a user-defined Environment Variable using the Administrator client.

chulett · Post by **chulett** » Tue May 31, 2011 6:54 am

Or that.

coface · Post by **coface** » Fri Jun 03, 2011 12:46 am

thanks, but my problem is: the setting in the dsenv file or in the user-defined enviroment has no effect to the orchdbutil tool.

the tool always shows the wrong setting on startup. The setting seems to be ignored.

chulett · Post by **chulett** » Fri Jun 03, 2011 7:14 am

Thought we were talking about a problem with your jobs rather than a specific tool. If you have it set in your dsenv file and source it before running the utility - that or set it explicitly in your user's environment - and it doesn't affect the behaviour of orchdbutil, then perhaps you should contact your official support provider. Could be a bug in your version, could be it requires a different approach or setting.