[EMAIL PROTECTED]
Sent by: "ADSM:cc
Dist Stor
Manager" Subject
<[EMAIL P
ent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
07/07/2003 08:18
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:Re: MVS select statement
Thank you all for your input!
The parentheses worked! Are the
Sent by: "ADSM: Subject: Re: MVS select statement
Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
07/07/2003 10:23
AM
Hi Joni,
I use the following select statement's to find out daily error messages.
The morning operators run this script each morning and notify an
administrator if there is a problem. In the following script I just pull
out certain messages, you can add or delete these to suit your needs. Some
o
t;[EMAIL PROTECTED]To: [EMAIL PROTECTED]
HERN.CO.UK> cc:
Sent by: "ADSM: Dist Stor Subject: Re: MVS select
statement
Manager"
<[EMAIL PROTECTED]>
Joni,
Is it possible that you missed a continuation character out in your sql
statement
John
Joni Moyer <[EMAIL PROTECTED]> on 07/07/2003 03:14:55 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSE)
Subject: MVS sele
AND has precendence over OR, so your "where" criteria are being evaluated
like this:
where cond1 OR (cond2 AND cond3)
In your case, "cond1" is for the messages of severity 'E', so those are
displayed regardless of the date.
Put parentheses around the ORed conditions to fix the problem:
wh
