Decimal Separator

asitagrawal · Post by **asitagrawal** » Tue Nov 20, 2007 4:12 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.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 20, 2007 5:37 am

NLS consists of two pieces - the character map (e.g UTF-8) and the locale. The locale is a means for representing different categories of data according to local expectations. The five categories are TIME (dates and times), NUMERIC, CURRENCY, CHARACTER (casing and categories) and COLLATE (sorting rules). I suspect your NUMERIC or CURRENCY locale is set to a European setting.

Project-wide settings are made in Administrator client; these defaults can be overridden at the job or stage level.

asitagrawal · Post by **asitagrawal** » Tue Nov 20, 2007 5:41 am

Hi Ray,

I have verified the locales for all 5 categories... all are set to US-ENGLISH.