Hi joni
you should put the first two constraines between parantheses ; like :
select date_time, msgno, message
   from actlog
   where (severity='E' or severity='W') and date_time>(current_timestamp-(1
day))

Hussein


                                                                           
             John Naylor                                                   
             <john.naylor@SCOT                                             
             TISH-SOUTHERN.CO.                                          To 
             UK>                       ADSM-L AT VM.MARIST DOT EDU              
  
             Sent by: "ADSM:                                            cc 
             Dist Stor                                                     
             Manager"                                              Subject 
             <[email protected]         Re: MVS select statement            
             .EDU>                                                         
                                                                           
                                                                           
             07/07/2003 04:39                                              
             م                                                             
                                                                           
                                                                           
             Please respond to                                             
             "ADSM: Dist Stor                                              
                 Manager"                                                  
             <[email protected]                                             
                   .EDU>                                                   
                                                                           
                                                                           




Joni,

Is it possible that  you missed a continuation character out in your sql
statement

John




Joni Moyer <joni.moyer AT highmark DOT com> on 07/07/2003 03:14:55 PM

Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>

To:   adsm-l AT vm.marist DOT edu
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  MVS select statement



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







**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************