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
As an Amazon Associate we earn from qualifying purchases.