I'm sure Jerry - it is only limited by the number of records you store and/or rebuild. I can only guess that whoever wrote the program you are talking about imposed their own limit of 9,999.

Like you I've done nothing but load all for many many years. As you say, nobody will page through 9,999 records. In fact I do load all and store the subfile images in memory so the subfile can be easily sorted.


On Nov 25, 2019, at 9:01 AM, Jerry Adams <midrange@xxxxxxxx> wrote:

Jon,

Are you sure about there not being a limit on the number of records for a
page-at-a-time subfile? I have a recollection of a colleague working on a
program that blew off at 9999, and all of our subfile programs used PAT
subfiles. (I couldn't believe that he actually pressed the Page Down key >
500 times to test a client's complaint!) But, maybe, this was the one
exception in our package. On the other hand, wouldn't a Load All
(expandable) subfile blow off on the first EXFMT? (Full disclosure: I've
never tried it to see what would happen.)

Anyway, I always use Load All subfiles; they are (for me, anyway) much
easier to code. I only tested for the 9999 limit once in > 20 years.
("Seriously? You're going to page through >9000 records?")

Jerry C. Adams
It costs nothing to be polite. -W.S. Churchill
IBM i Programmer/Analyst
--
NMM&D
615-832-2730

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
Jon Paris
Sent: Sunday, November 24, 2019 2:27 PM
To: Midrange Systems Technical Discussion
Subject: Re: main difference between expandable and singlepage subfile

In a single page subfile all page up/down requests must be handled by
program logic.

In an expandable subfile once a record has been added to the subfile the
system will take care of page up/down requests. The program only has to
worry about adding additional records (if there are any) to the end of the
subfile when a page request attempts to go beyond the number of records
currently loaded.

Single page subfiles have no maximum size since it is up to the program to
control what data is displayed. Expandable subfiles are limited to 9,999
records - unless only used with an Open Access handler then the limit s much
higher.



On Nov 24, 2019, at 3:09 PM, techie21 IT <techiei876@xxxxxxxxx> wrote:

---------- Forwarded message ---------
From: techie21 IT <techiei876@xxxxxxxxx>
Date: Mon, Nov 25, 2019 at 1:35 AM
Subject: main difference between expandable and singlepage subfile
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>


Hi,

What is main difference between expandable and singlepage subfile ?

Thanks
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

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