Maybe you could create a LF the way you want but with no member. I don't know if RGZPFM would honor it but it would be quick to test out.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Thursday, February 13, 2020 12:40 PM
To: Midrange Systems Technical Discussion
Subject: RE: SQL method of RGZPFM?

One of the main reasons I do not like using KEYFILE(...) is that most existing 'traditional' logical files have select/omit criteria. For example only selecting 'active' records. You cannot use a logical file with select/omit specified as the parameter in KEYFILE. To me it inherently makes sense to sort the inactive and active apart from each other.
I fully get that one can never count on the order a row is retrieved except by specifying selection and/or order by criteria. I am concerned however with performance and it does help performance to have the rows physically sorted.

Rob Berendt

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by 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].