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 > problem: sum is...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 8894 of 9520
Post > Topic >>

problem: sum is incorrect (e-10)

by DM <diemme29@[EMAIL PROTECTED] > May 19, 2008 at 08:29 AM

Hi all,
I've a problem.

The query select mo_qta from oobjm.movoptittraded where mo_opzione =
'1,253CEUUS16M08' gives:
MO_QTA
------------------------
  +2.50347710000000E+005
  +2.50347710000000E+005
  +2.50347710000000E+005
  +3.33796940000000E+005
  +1.00139082000000E+006
  -2.50347710000000E+005
  -2.50347710000000E+005
  -2.50347710000000E+005
  -3.33796940000000E+005
  -1.00139082000000E+006

and the query select sum(mo_qta) from oobjm.movoptittraded where
mo_opzione = '1,253CEUUS16M08' gives:
1
------------------------
  +3.49245965480804E-010

The field is a double.

I think is impossible...
How can i find where the problem is?

Thanks all,
DM
 




 4 Posts in Topic:
problem: sum is incorrect (e-10)
DM <diemme29@[EMAIL PR  2008-05-19 08:29:39 
Re: problem: sum is incorrect (e-10)
Serge Rielau <srielau@  2008-05-19 11:43:36 
Re: problem: sum is incorrect (e-10)
"Dave Hughes" &  2008-05-19 11:20:31 
Re: problem: sum is incorrect (e-10)
DM <diemme29@[EMAIL PR  2008-05-20 07:21:08 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Tue Dec 2 20:32:48 CST 2008.