Fw: Difference between Select and Omit in LF

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:

PSATFG  PSSTCD    COUNT ( * )
  A       10               43
  A       30              104
  A       40               56
  A       50           33.957
  A       59                2
  B       70           20.195
  D       59              892

How come the *OR-ed omit only takes a few milli's but the *AND-ed select
and omit take as long as the *OR-ed select?

DB performance obviously is not my best subject...

Peter
----- Forwarded by Peter Colpaert/HE/EU/HONDA on 13/05/2004 07:58 -----

Peter Colpaert/HE/EU/HONDA
13/05/2004 07:51
 NAC-4-200-334

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

Subject
RE: Difference between Select and Omit in LF





Okay, now I get it: if you want the two conditions to be *AND-ed, you need
to leave off the second 'S' or 'O'.

Knew it was something stupid that I overlooked.  I assumed that the
conditions would always be *AND-ed.

Thanks to all those who responded.

Peter



"Lokesh Gupta" <Lokesh.Gupta@xxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/05/2004 23:40
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: Difference between Select and Omit in LF






Actually,
>A          S PSATFG                    COMP(EQ 'A')
>A          S PSSTCD                    COMP(LT '30')
would be same as
>A          O PSATFG                    COMP(NE 'A')
>A             PSSTCD                    COMP(GE '30')


and would also give the same result, the first logical is PSATFG = 'A' or 
PSSTCD < '30'
and the second would be PSATFG <> 'A' and PSSTCD > '30'


regards,
Lokesh

regards,
Lokesh Gupta,
Infosys Technologies Ltd.,
Work: 239-274-4855
Mobile: 239-839-7673
www.infosys.com



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.