RE: Logical with two selects

["Dwayne Allison" <Dwayne.Allison@xxxxxxxxx>]

Thanks it work great!

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Erich W. Schasse
Sent: Wednesday, August 25, 2004 8:43 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Logical with two selects


Hi Dwyane,

try with only on S.

S PMKREI                    VALUES(' ') 
  PMKINF                    VALUES('Y') 

HTH

Kind regard

i.A. Erich W. Schasse

WIEDEMANN GmbH & Co. KG
IT/ORG
Wiedemannstr.
31157 Sarstedt
Tel. 05066/997-190  
Fax  05066/997-366
mailto:schasse@xxxxxxxxxxxx
www.wiedemann.de



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Dwayne Allison
Sent: Wednesday, August 25, 2004 3:14 PM
To: Midrange Systems Technical Discussion
Subject: Logical with two selects


How do you set up a logical file to select only records with two different
values?


Example:

I have a file that I want to select the PMKREI that equal *blanks and PMKINF
fields that equal 'Y'.

I have it set with the two select now and it pull all the records with
PMKREI the equal blank and the PMKINF equal blank. It also pull records that
have PMKINF = 'Y' and PMKREI = 'I'.


S PMKREI                    VALUES(' ') 
S PMKINF                    VALUES('Y')