ADSM-L

MVS select statement

2003-07-07 10:15:45
Subject: MVS select statement
From: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 7 Jul 2003 10:14:55 -0400
Hello all!

I have been trying to set up a select statement to look for all of the
error and warning messages within the past 24 hours.  Here is what I have
come up with:

select date_time, msgno, message
   from actlog
   where severity='E' or severity='W'
   and date_time>(current_timestamp-(1 day))

My problem is that it goes through the entire 14 days of the activity log
that I have and ignores the last statement.  Any suggestions?

Thanks in advance!!!


**************************************
             Joni Moyer
     Systems Programmer
   joni.moyer AT highmark DOT com
          (717)975-8338

<Prev in Thread] Current Thread [Next in Thread>