Re: Subfiles:Displaying 10,000th record

[Patrick Shrader <pshrader@xxxxxxxxxxxx>]

Kathie,

I would reccomend that you program the subfile as a "page-at-a-time"
subfile. Essentially, you trap for the roll key indicators, and load 10-15
records at a time (reading from the data file in the correct order to match
the roll key direction). This would allow you to control position to
loading quickly (since you are only loading 10-15 records in memory instead
of 10,000+!). Set subfile size equal to subfile page, and monitor for the
roll keys: ROLLUP(50) or ROLLDOWN(51).


The tricky part of this is when you roll backwards from the first record in
the file -- trying to reach record #25,000 from page 1. This can be
overcome with some conditioning logic.

It is also harder to work with if you are updating information in the
subfile. If so, update a workfile with the same information as you edit
check the subfile.

This should greatly improve load and execution time, if you can overcome
the shortcomings.

At 03:57 AM 3/13/99 EST, you wrote:
>Ok, I was just mentioning the topics of this forum at my team meeting this
>week.... Including the 10,000 record  subfile.... and at the end of the week
>(Friday)... I have someone that came to me because they need the actual
>answer..... soooooo.  What is the final scuttlebutt on the 10000 record sf?
>Cuz we have one blowing up... Thank-you...Please...... and Thank-you
>again....!!! Kathie


------------------------------------------------------------
Patrick Shrader 
pshrader@foodcity.com
Systems Analyst
K-VA-T Food Stores/Food City

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *