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.
Comma or decimal point
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
Re: Comma or decimal point
Use Float as the data type, instead of decimal.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA