Hi,
Source is Oracle[decimal(15,3)] and target is dataset[decimal(15,3)].
from source 10000024.35 data is coming but when i m viewing in dataset it is stored as [ 000010000024.350],that means 13 integer and 3 decimal part.but length is defined as decimal(15,3).can anyone please help me.
Thanks in advance.
column is taking more than defined length in dataset
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are 15 digits in 000010000024.350 (count them). That means decimal[15,3] in my book. "Precision" is the number of digits in the number, not the number of digits to the left of the decimal place.
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.
As noted, precision is the total number of digits in the number, not the number to the left of the decimal. Scale is the portion of the precision to the right of the decimal.
So, a decimal(3,2) could not store 10 as a value.
ps. Don't count the decimal in the precision.
So, a decimal(3,2) could not store 10 as a value.
ps. Don't count the decimal in the precision.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanx for ur kind suggession.
I think you are mistaken,[ 000010000024.350] is taking 13 places for integer,as there is a blank space before 0 at the starting place.
later my reqirement is to write this dataset into a fixed width file having length(15,3)but my file is also occupying 16 places instead of 15.
I think you are mistaken,[ 000010000024.350] is taking 13 places for integer,as there is a blank space before 0 at the starting place.
later my reqirement is to write this dataset into a fixed width file having length(15,3)but my file is also occupying 16 places instead of 15.
ambasta
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: