Re: MVS select statement
2003-07-07 10:51:54
I actually entered this command from the gui command line. The tsm server
is on os/390 2.10 at version 5.1.6.2. (I'm not sure if this makes a
difference). Thanks!
Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338
John Naylor
<john.naylor@SCOTTISH-SOUT To: ADSM-L AT
VM.MARIST DOT EDU
HERN.CO.UK> cc:
Sent by: "ADSM: Dist Stor Subject: Re: MVS
select statement
Manager"
<ADSM-L AT VM.MARIST DOT EDU>
07/07/2003 10:39 AM
Please respond to "ADSM:
Dist Stor Manager"
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.
**********************************************************************
|
|
|