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.
**********************************************************************