double rounding in gui tools

[apattin]

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

[Serge Rielau]

apattin wrote:

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

This is CLI.

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

2.173

This is JDBC

So the short answer is the server has nothing to do with it.
Maybe there is a Preferences option of sorts in the commandEditor?

Have you tried dataStudio?

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab