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

Rick,

Care to send an example of your DDS? AFAIK, the syntax goes something like
this:

S FIELD1 COMP(EQ 'Y')
FIELD2 COMP(EQ 'Y')

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Tue, Jul 20, 2010 at 9:04 AM, <Rick.Chevalier@xxxxxxxxxxxxxxx> wrote:

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.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.