Page 1 of 1
Posted: Fri Nov 10, 2017 5:13 pm
by ray.wurlod
What are the NLS settings for Oracle? Have you mapped these in DataStage?
Posted: Thu Nov 16, 2017 7:47 am
by joycerecacho
ray.wurlod wrote:What are the NLS settings for Oracle? Have you mapped these in DataStage? ...
Any idea, guys?
Where do I need to set to extract exactly the source characters, without replace some special chars by '?' ?
I tried to set NLS options at the Administrator (Paralllel Maps): UTF-16, UTF-8, ISO-8859-10, ISO-8859-1 but none of them worked.
Any tip?
Thanks in advance.
Posted: Thu Nov 16, 2017 8:04 am
by qt_ky
When I am extracting from Oracle, I usually find it is sufficient to take the Oracle database's NLS_LANG value and set the same thing as an environment variable at the DataStage project level in the DataStage Administrator project settings' Environment.
Posted: Thu Nov 16, 2017 12:34 pm
by qt_ky
We don't set any existing environment variable; we add a new one named NLS_LANG and give it a default value that matches the same NLS_LANG value reported by Oracle.
Posted: Thu Nov 16, 2017 12:44 pm
by joycerecacho
At the result, we have NLS_LANGUAGE = 'BRAZILIAN PORTUGUESE'.
Do you mean set the new environment variable with this content?