Re: Can I have 'and' condition using DDS COMP keyword?

Rick,
You need to specify each condition on separate lines, with the "S" on the first
line only.
If you place an "S" on each line, that creates at *or* condition.
By leaving the "S" on the first line only, you get an *and* condition.



Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical
Solutions Implementer V5R3









________________________________
From: "Rick.Chevalier@xxxxxxxxxxxxxxx" <Rick.Chevalier@xxxxxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Tue, July 20, 2010 9:34:55 AM
Subject: Can I have 'and' condition using DDS COMP keyword?

It has been way too many years since I had to use DDS for select/omit criteria
in a logical file. I am trying to create an index with two selection
conditions. No matter what I do the results are everything meeting condition 1
or condition 2. What I want is everything meeting condition 1 and condition 2.

I tried searching the archives but came up empty. I might not have done a good
job of defining my search terms though. The DDS reference didn't give any
examples of an and condition, just or conditions which makes me think it can't
be done. I'm pretty sure I did this in the (distant) past though.

We are at 5.4 so I can't use the new SQL feature to create an index with
selection criteria.


Rick Chevalier
IT Software Solutions - Loan Servicing
[http://www.americredit.com/images/acf_email_sig.gif]
817-525-7178 (w)
rick.chevalier@xxxxxxxxxxxxxxx<mailto:rick.chevalier@xxxxxxxxxxxxxxx>



________________________________
Privileged and Confidential. This e-mail, and any attachments there to, is
intended only for use by the addressee(s) named herein and may contain
privileged or confidential information. If you have received this e-mail in
error, please notify me immediately by a return e-mail and delete this e-mail.
You are hereby notified that any dissemination, distribution or copying of this
e-mail and/or any attachments thereto, is strictly prohibited.