Re: Fw: Difference between Select and Omit in LF

Mike,

Okay, now it's making sense.

My idea was that the select/omit did the following

SELECT those where PSATFG = 'A' AND PSSTCD < '30'

versus

OMIT those where PSATFG <> 'A' AND OMIT those where PSSTCD >= '30'

which I thought should produce the same result.

Guess I was wrong (obviously).

But 'basic boolean algebra' was not in my math classes waaaaaay back, so I
plead ignorance ;-)  Don't even know if it's

Thanks,

Peter



"Michael Naughton" <michael_naughton@xxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
13/05/2004 21:34
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Fw: Difference between Select and Omit in LF






Peter,

The select will only be equivalent to the omit if one is ANDed and the
other is ORed, i.e.:

SELECT (X AND Y)
is equivalent to
OMIT (NOT X OR NOT Y)

and

SELECT (X OR Y)
is equivalent to
OMIT (NOT X AND NOT Y)

so first you have to figure out which pair will give you the results
you're looking for, and then set up your logicals accordingly.

hth,

PS: the above is basic Boolean algebra . . . .


RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> writes:
>Now I don't get it anymore...
>
>I changed both versions to have only the first 'S' or 'O', and now indeed

>both take the same amount of time - the LONG time!
>
>This is the data that I'm processing:


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.





The information contained in this communication is confidential and may be 
legally privileged. It is intended solely for the use of the individual or the 
entity to whom it is addressed and others authorised to receive it. If you have 
received it by mistake, please let the sender know by e-mail reply and delete 
it from your system.
If you are not the intended recipient you are hereby notified that any 
disclosure, copying, distribution or taking any action in reliance of the 
contents of this information is strictly prohibited and may be unlawful.
Honda Europe NV is neither liable for the proper and complete transmission of 
the information contained in this communication nor for any delay in its 
receipt.