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.7816537541483 3E+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
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.7816537541483 3E+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