MVS select statement
2003-07-07 10:15:45
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>
|
- MVS select statement,
Joni Moyer <=
|
|
|