column is taking more than defined length in dataset

[ambasta]

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.

[ray.wurlod]

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.

[chulett]

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.

[ambasta]

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.

[madhukar]

Space at starting of a decimal specifies the "sign position" which is a default property. Space indicates a positive value.
To avoid the space you have to set the field width property.

[ambasta]

If this space is coming in dataset,it is ok for me.but when i m writing to sequential fixed width file this blank space is also taking one space.this i do not want..can you plz suggest me any alternative.

Thanks in Advance.

[ray.wurlod]

Convert to string and trim the leading space character. Note that this may produce wrong answer if your numeric value is negative.