Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Repost (sort of) of an old problem

0 views
Skip to first unread message

apattin

unread,
Apr 21, 2008, 6:01:37 PM4/21/08
to
Hi,

I have been trying to find a reasonable GUI SQL client that displays
results without rounding them. I was pointed to IBM's Data Studio,
which we've FINALLY installed, but sadly it seems it also rounds. If I
do this query from the command line:

SELECT * FROM TARGET WHERE file_id = 8237 and accession_id =
'200928_s_at'

I get:

FILE_ID ACCESSION_ID
MEASURE
----------- ------------------------------ ------------------------
8237 200928_s_at -2.78165375414833E+000

If I do the same exact thing in Data Studio I get:


8237 200929_s_at -2.782


I was also told this was JDBC, but there has to be a way to disable
rounding, eh? Can anyone help?

Thanks a lot,

Alejandrina

0 new messages