Hi Gurus,
I have an attribute which talks about INTEREST_PERCENTAGE(15.12345) , is there a way to define a column as decimal(2,5) in datastage,
as a basic standard that precision can be equal are greater than scale.
Please provide your valuable inputs.
Thanks
Kishore
Define decimal(2,5) in datastage ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Decimal(2,5) does not fit anywhere.
The first number (precision) is the number of significant digits.
The second number (scale) is the number of digits after the decimal place.
You can't have five digits after the decimal place if you only allow two significant digits.
The first number (precision) is the number of significant digits.
The second number (scale) is the number of digits after the decimal place.
You can't have five digits after the decimal place if you only allow two significant digits.
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.
From what I've seen, not every system includes the scale in the precision. The vast majority, yes, but it's not an absolute from what I recall. Just don't ask me to clarify where, though, it's just something waving weakly from the back of my mind for attention.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers