|
Hi Peter, Could this be the difference: Index size . . . . . . . . . . . . . . : 1056768 vs: Index size . . . . . . . . . . . . . . : 24576 Seems like the 'omit' version has a lot less data to index or process. Fred Underwood North American Stainless (502) 347-6187 mailto:funderwood@xxxxxxxxxxxxxxxxxxxxxxxxxx "Peter Colpaert" <Peter.Colpaert@xxxxxxxxxxxx> Sent by: rpg400-l-bounces@xxxxxxxxxxxx 05/12/2004 09:24 AM 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 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. _______________________________________________ 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
