This is an example of -and-
A S IMCTRL COMP(EQ 0)
A IMDCORE COMP(EQ ' ')
this is an example of -or-
A S IMCTRL COMP(EQ 0)
A S IMDCORE COMP(EQ ' ')
after a select or omit condition is specified a blank in pos 17 of the next line means AND
as S or O in the next line means OR
suggest bring up a ds ref for phy and lgl files as a pdf and doing a search on select.
Jim Horn
message: 4
date: Tue, 20 Jul 2010 08:34:55 -0500
from: <Rick.Chevalier@xxxxxxxxxxxxxxx>
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>
This email is intended only for the person or entity
to which it is addressed and may contain information
that is privileged, confidential or otherwise protected
from disclosure. If you are not the named addressee
or an employee or agent responsible for delivering
this message to the named addressee, you are not
authorized to read, print, retain copy, and disseminate
this message or any part of it. If you have received this
message in error please notify us immediately by email,
discard any paper copies and delete all electronic files
of this message.
midrange.com
