Did yur suggestion and I got an error back, please look below syntax and see if I'm doing anything wrong:
select DB2INST1.REPORT ER_STATUS_NEW.C ONSUMER, DB2INST1.REPORT ER_STATUS_NEW.S EVERITY
from DB2INST1.REPORT ER_STATUS_NEW where timestamp BETWEEN '2012-05-01 10:00:00' and '2012-05-02 12:00:00')
and DB2INST1.REPORT ER_STATUS_NEW.S EVERITY > 3 GROUP BY DB2INST1.REPORT ER_STATUS_NEW.C ONSUMER, DB2INST1.REPORT ER_STATUS_NEW.S EVERITY...
akimalik10
Last Activity: May 3 '12, 10:34 PM
Joined: May 3 '12
Location:
-
akimalik10 started a topic How to retrieve alerts/information from a db of alerts that happened between 7in DB2How to retrieve alerts/information from a db of alerts that happened between 7
I'm trying to retrieve alerts/information from a db of alerts that happened between 7 a.m to 7:30p.m, can someone pls give me a detailed db2 select statement on how I can accomplish this?
No activity results to display
Leave a comment: