Hi
My source column data is coming as decimal(12,3) and i have to insert into target column with data type as decimal (9,2).
I have used decimalto decimal(column,"floor").It was not working.
Is there any other possible solution for this?
Thanks!
conerting a decimal(12,3) to decimal (9,2)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Tue Jan 18, 2005 5:48 am
DecimalToDecimal should work. you have some option in Modify stage as well. I dont have access to DS right now to get you the right info. But you can optionally convert it to char and trim the 0's it if required and convert it back to decimal.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What will happen when the source value is too large to fit in a decimal[9,2] field?
Please post your exact decimal_to_decimal specification (I am assuming here that you are using a Modify stage).
Please post your exact decimal_to_decimal specification (I am assuming here that you are using a Modify stage).
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.