I have input of char( 8 ), how to convert it to decimal ( 8,8 ) in a transform stage.
it's working fine to convert decimal ( 8,0 ).
Stringtodecimal conversion error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Precision must be at least one larger than scale. Decimal(8,8) is not an acceptable formulation; you need at least Decimal(9,8) to accommodate eight decimal places.
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: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's just something I've noticed over the years. Decimal[N,N] should be able to represent numbers between zero and less than 1.0, theoretically, but it seems that some implementations need to be able to specify that there is a digit to the left of the decimal place holder.
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.