Comma or decimal point

shrek7577 · Post by **shrek7577** » Tue Dec 19, 2006 8:29 am

Hi,

Our DS server/client version is 7.1r1

All our input file are in CSV format (; as separator).

They are generated by excel (french version) which put ',' for decimal number and sometimes with spaces.

But, in datastage, decimal must be with comma '.'

So, for all decimal derivations, I'va to use TRIM, CHANGE, ...

Do it exist some parameters in DS to solve this problem ? NLS ?

Thanks.

asitagrawal · Post by **asitagrawal** » Tue Dec 19, 2006 10:39 am

Use Float as the data type, instead of decimal.

kumar_s · Post by **kumar_s** » Tue Dec 19, 2006 5:09 pm

Try to customize you own data element.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 19, 2006 5:26 pm

If you have NLS enabled for DataStage, do the following in the Transformer stage.

Use ExecUV as a before-stage subroutine to execute the command SET.LOCALE NUMERIC FR-FRENCH

Use ExecUV as an after-stage subroutine to execute the command RESTORE.LOCALE

Then DataStage will automatically recognize the French convention for thousands delimiter (space) and decimal placeholder (comma).

shrek7577 · Post by **shrek7577** » Wed Dec 20, 2006 11:05 am

Thanks a lot !
I replace Decimal Type by Float for the decimal and it work perfectly (with Oracle 9i plugin)
:D

us1aslam1us · Post by **us1aslam1us** » Wed Dec 20, 2006 11:08 am

Its nice that you resolved that but Ray's suggestion is worth giving a try.

Sam

shrek7577 · Post by **shrek7577** » Fri Dec 22, 2006 7:18 am

hi us1aslam1us and ray.wurlod,

ok, i save this page in my pc and will try it later.

Thanks.

DSXchange

Comma or decimal point

Comma or decimal point

Re: Comma or decimal point