Page 2 of 2
Posted: Fri Nov 23, 2007 12:37 pm
by kcbland
If your install "accidentally" involved NLS support and you DON'T need it, then you should de-install the engine and do a fresh install. This is the first of many small discrepancies between NLS and non-NLS installations. You're going to go crazy trying to find all functions that operate just a little bit different. Checkout the TIMEDATE() function results on non-NLS and NLS systems, for example. ICONV/OCONV is another. Save yourself non-stop hassle and fix it NOW.
Posted: Wed Nov 28, 2007 12:11 am
by saikrishna
D-YMD[4,2,2] is working fine.
To solve unknown problems, I want to disable NLS.
As NLS is installed in new DS Server 7.5.2, Is there any way to disable NLS, to make ICONV/OConv functions to work properly?
Thanks
Sai
Posted: Wed Nov 28, 2007 12:15 am
by ray.wurlod
Iconv() and Oconv() work properly whether or not NLS is enabled.
Some conversions behave differently, but it is proper in each case.
You can disable/enable NLS via the NLSMODE configuration parameter in the uvconfig file. To change you must shut down DataStage, edit the file, regenerate, and start DataStage.
Posted: Wed Nov 28, 2007 8:09 am
by chulett
I posted how to disable it earlier in this thread.