RE: Difference between Select and Omit in LF -- RPG400-L

Reeve,

where do I see this on DSPFD?  The following data was what I think is
relevant here:

Select/Omit Description
  Dynamic selection . . . . . . . . . . . . . : DYNSLT     No
  Number of rules . . . . . . . . . . . . . . :               3
  Format  . . . . . . . . . . . . . . . . . . :            PSMAST
    Field . . . . . . . . . . . . . . . . . . :            PSATFG
      Rule  . . . . . . . . . . . . . . . . . :            SELECT
      Comparison  . . . . . . . . . . . . . . :            COMP EQ
      Value . . . . . . . . . . . . . . . . . :            'A'
    Field . . . . . . . . . . . . . . . . . . :            PSSTCD
      Rule  . . . . . . . . . . . . . . . . . :            SELECT
      Comparison  . . . . . . . . . . . . . . :            COMP LT
      Value . . . . . . . . . . . . . . . . . :            '30'
    Field . . . . . . . . . . . . . . . . . . :
      Rule  . . . . . . . . . . . . . . . . . :            OMIT
      Comparison  . . . . . . . . . . . . . . :            ALL
  Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ     *HEX
  Language identifier . . . . . . . . . . . . : LANGID     NLB

<snip>

Share open data path  . . . . . . . . . . : SHARE      *NO
Access Path Activity Statistics . . . . . :
  Access path logical reads . . . . . . . :
  Access path physical reads  . . . . . . :
  Index size  . . . . . . . . . . . . . . :                    1056768
  Access path valid . . . . . . . . . . . :            Yes
  Implicit access path sharing  . . . . . :            No
  Access path journaled . . . . . . . . . :            No
  Number of unique partial key values . . :
    Key field 1 . . . . . . . . . . . . . :                         26
    Key fields 1 - 2  . . . . . . . . . . :                       3398
    Key fields 1 - 3  . . . . . . . . . . :                       9228
Last change date/time . . . . . . . . . . :            12/05/04  15:15:07
Extract date/time . . . . . . . . . . . . :            23/08/28  12:03:06
Last extract date/time  . . . . . . . . . :            23/08/28  12:03:06

And for the other file:

Select/Omit Description
  Dynamic selection . . . . . . . . . . . . . : DYNSLT     No
  Number of rules . . . . . . . . . . . . . . :               3
  Format  . . . . . . . . . . . . . . . . . . :            PSMAST
    Field . . . . . . . . . . . . . . . . . . :            PSATFG
      Rule  . . . . . . . . . . . . . . . . . :            OMIT
      Comparison  . . . . . . . . . . . . . . :            COMP NE
      Value . . . . . . . . . . . . . . . . . :            'A'
    Field . . . . . . . . . . . . . . . . . . :            PSSTCD
      Rule  . . . . . . . . . . . . . . . . . :            OMIT
      Comparison  . . . . . . . . . . . . . . :            COMP GE
      Value . . . . . . . . . . . . . . . . . :            '30'
    Field . . . . . . . . . . . . . . . . . . :
      Rule  . . . . . . . . . . . . . . . . . :            SELECT
      Comparison  . . . . . . . . . . . . . . :            ALL
  Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ     *HEX
  Language identifier . . . . . . . . . . . . : LANGID     NLB

<snip>

Share open data path  . . . . . . . . . . : SHARE      *NO
Access Path Activity Statistics . . . . . :
  Access path logical reads . . . . . . . :                           288
  Access path physical reads  . . . . . . :
  Index size  . . . . . . . . . . . . . . :                      24576
  Access path valid . . . . . . . . . . . :            Yes
  Implicit access path sharing  . . . . . :            No
  Access path journaled . . . . . . . . . :            No
  Number of unique partial key values . . :
    Key field 1 . . . . . . . . . . . . . :                         10
    Key fields 1 - 2  . . . . . . . . . . :                         28
    Key fields 1 - 3  . . . . . . . . . . :                         40
Last change date/time . . . . . . . . . . :            12/05/04  11:00:34
Extract date/time . . . . . . . . . . . . :            23/08/28  12:03:06
Last extract date/time  . . . . . . . . . :            23/08/28  12:03:06

I don't quite see any relevant difference between both files.

Thanks,

Peter



"Reeve" <news@xxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/05/2004 14:58
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






Peter, how about using DSPFD to see if either LF's access path is shared?

Regards,
Reeve Fritchman
Ayers Rock Software LLC
4915 S. West Shore Boulevard
Tampa, Florida 33611-3329
(813) 831-8574 (voice)
(813) 832-6391 (fax)







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.