Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Repost (sort of...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 8810 of 9131
Post > Topic >>

Repost (sort of) of an old problem

by apattin <apattin@[EMAIL PROTECTED] > Apr 21, 2008 at 03:01 PM

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
 




 1 Posts in Topic:
Repost (sort of) of an old problem
apattin <apattin@[EMAI  2008-04-21 15:01:37 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 6:20:00 CDT 2008.