floating point decimal is not fully supported.....

brunix · Post by **brunix** » Tue Aug 30, 2005 9:15 am

This is the complete error :

" Column IMPT_RTLZ floating point decimal is not fully supported; adjusting the scale."

The column have 38 lenght and 10 as scale.

Some one can help me about resolving this warning ?

elavenil · Post by **elavenil** » Tue Aug 30, 2005 9:18 am

When this error occurred? What is your source? Are you encountering this error while loading into target table?

Pls give us more info, which would help everyone to understand the problem and suggesst solution based on that.

Regards
Saravanan

brunix · Post by **brunix** » Tue Aug 30, 2005 9:43 am

Ok.
I try to explain (sorry for my english)
This warning appear on an Oracle source stage.
In the select I do a sum of a decimal (15,2) field.
In the colum definition I have to define this calculated field like a floatin 38,10.
This is the problem. Datastage don't assign the same format to a field and to a sum of this.
One solution is to do the sum outside of Oracle stage and add an aggregator stage.
I post this message to don't use this solution. I want to find the right field format to continue to use the SUM in the oracle stage.
Thanks in advance,
Brunix

ray.wurlod · Post by **ray.wurlod** » Tue Aug 30, 2005 4:06 pm

The warning is to alert you that the same data type as the source values may not be large enough to accommodate their sum.

Consider int8 as an easy example, the largest value of which is +127. You don't have to add too many of these to exceed +127. Therefore a more appropriate data type for the sum is something larger, perhaps int16.

The same is true with decimal[n,x]; the data type of the sum should perhaps be decimal[(n+2),x].

Another problem that might occur with the dfloat data type (which is definitely large enough!) is that loss of precision may occur. Because of the manner in which computers store floating point numbers, there may not be sufficient precision available to store the n significant digits of a decimal[n,x] data type.

Create a message handler to demote this warning to informational.

brunix · Post by **brunix** » Fri Sep 02, 2005 7:00 am

Thanks.
I found a solution.
In the Oracle stage I make a TO_CHAR(SUM(.....)) and I defined the field like varchar(40).
In the following transformer I convert the field with a StringToDecimal function in a decimal(15,2).
The warning disappear !!!
Thanks at all for help,
Brunix