Hi All,
i am having one of the column named in a Sql table named - 'ITEM_R(Numeric (5,0)).there are 2 values for this column i.e; 3,131 & 5,243
Now when i pull this column in the Data-stage Extract and see the data then i see the following values i.e; 03131. & 05243.
so my req was to replace the . at the end with -i.e; 03131- & 05243-
replace . with -
Moderators: chulett, rschirm, roy
replace . with -
Sri.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You've changed the meaning of your data.
A "." at the end means a decimal data type with 0 decimal places.
A "-" at the end means an integer with a value less than zero.
A "." at the end means a decimal data type with 0 decimal places.
A "-" at the end means an integer with a value less than zero.
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.
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney