Repost (sort of) of an old problem

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • apattin

    Repost (sort of) of an old problem

    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

Working...