Hi,

I am trying to understand why (and when) DB2 rounds double values.
Example:

(a) Using CLP, I do this query

SELECT ref_value FROM stz_target_data WHERE version = '6.2' and g_name
= 'XXX'

I get this result:

+2.17262381600000E+000

(b) I do the same thing in the Command Editor, I get:

2.173

(c) If I click on the ref_value column it shows me the value with all
its digits, but if I then export the results, they are rounded!

How can I control the rounding?

Thanks,

Alejandrina