Decimal Separator

[asitagrawal]

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.