How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

DB2 LUW shows rounded numbers instead of the actual value

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

I have a DB2 double column with values like 0.127, 1.14444 and so on. When I select that column DBvis returns 0.13 and 1.14 for those examples. It seems that the driver itsself is returning rounded values. My DB admin says his DB2 tools show correct values with all digits. What could be wrong and what could be done? I have attached the column definition as screen shot. *Mathias*
1 Comment
[This reply is migrated from our old forums.]

Re: DB2 LUW shows rounded numbers instead of the actual value
Mathias, What are the setting for Decimal Number Format in Tools->Tool Properties and in the Data Types category? What happen if you try some other format? Regards Roger
Comments to this discussion are now closed!
More topics in Support
See all 1311 topics