Unix Technical Forum

SEO

vBulletin Search Engine Optimization


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-24-2008, 06:07 PM
apattin
 
Posts: n/a
Default 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.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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 05:47 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145