Decimal Separator
Posted: Tue Nov 20, 2007 4:10 am
Hi,
The existing Datastage server (7.5.1A, server edition) is installed on Windows 2000. The NLS (UTF - 8 ) is enabled for it.
I have now installed Datastage server (7.5.2, server edition) on another Windows 2000 machine. The NLS (UTF - 8 ) is enabled for it.
I have imported a job from 7.5.1A to 7.5.2. The job uses a DRS stage, accessing DB2 UDB data. When I use View Input Data option on 7.5.1A, then the decimal separator is (.) Dot BUT when I view it on 7.5.2, the decimal separator changes to (,) Comma !!
I have searched the forum for some soultion.. but all of them suggest to use CONVERT or EREPLACE functions..
Please advice me.
The existing Datastage server (7.5.1A, server edition) is installed on Windows 2000. The NLS (UTF - 8 ) is enabled for it.
I have now installed Datastage server (7.5.2, server edition) on another Windows 2000 machine. The NLS (UTF - 8 ) is enabled for it.
I have imported a job from 7.5.1A to 7.5.2. The job uses a DRS stage, accessing DB2 UDB data. When I use View Input Data option on 7.5.1A, then the decimal separator is (.) Dot BUT when I view it on 7.5.2, the decimal separator changes to (,) Comma !!
I have searched the forum for some soultion.. but all of them suggest to use CONVERT or EREPLACE functions..
Please advice me.