Hi,

I have data in my STAT table as follows

TSTAMP QMGR QNAME ENQ DEQ
... .. ...... 59 1
.. .. ... 59 29
... .. ... 59 58

... e.t.c

I want out put as follows

QMGR QNAME Total Enqueues Total Dequeues
PQM1 CUST.LOC 1000 1000
QMBK XML.PS.CS 800 1200

... e.t.c

So i wrote my query like this
db2 => SELECT QMGR, QNAME, SUM(ENQ), SUM(DEQ) FROM DB2A.STAT GROUP BY QMGR, QNAME

it seams, it did not give me sum of ENQ, DEQ are correct.

Please correct me

Thanks

Sorry, i guess it's working correct.
if you don't agree please let me know the correct one.

Thanks