Db2 Bigdecimal to Real conversion error

sselvakumar72 · #1 (**permalink**) 12-12-03, 11:53

Hi All,
I am trying to insert java BigDecimal object into Db2 real column type. This works fine in general. However, when I have a 9 digit number, rounding takes place. For eg, when I am trying to insert 1234567.89 into real type column, the data stored in the db2 column is 1234567.85

Could anyone tell me how to avoid this rounding. The above occurs only for 9 or more digit numbers.

Thanks
Sk

achiola · #2 (**permalink**) 12-12-03, 13:16

Hi,
Where you see this value rounding?

jsander · #3 (**permalink**) 12-12-03, 13:28

Hi,

datatype REAL's internal represantation is 4 bytes long. Try to store in DOUBLE instead and you should be fine.

BTW, with REAL I got a loss of accuracy when I went from 7 to 8 digits. So after all, you are not that bad off!

Johann

Quote:

Originally posted by sselvakumar72
Hi All,
I am trying to insert java BigDecimal object into Db2 real column type. This works fine in general. However, when I have a 9 digit number, rounding takes place. For eg, when I am trying to insert 1234567.89 into real type column, the data stored in the db2 column is 1234567.85

Could anyone tell me how to avoid this rounding. The above occurs only for 9 or more digit numbers.

Thanks
Sk

Internet Services

Web Development

Digital Marketing

Consumer Tech