RE: Subfiles:Displaying 10,000th record

Hi,
Thankyou for ur reply.Pls send me the program u mentioned.
Also u've mentioned Position to is easy in a Pagenated SFL.Do u mean to 
say that the pointer should be positioned to the required record in the 
database file before loading into the SFL.Pls clarify.
Thanks in advance.


>From: Alan Yates <alanyates@freenet.co.uk>
>Reply-To: RPG400-L@midrange.com
>To: "'RPG400-L@midrange.com'" <RPG400-L@midrange.com>
>CC: "'jason_vine@sgsgroup.com'" <jason_vine@sgsgroup.com>
>Subject: RE: Subfiles:Displaying 10,000th record
>Date: Tue, 9 Mar 1999 03:46:26 -0000
>
>You say "apart from paginated subfiles.." suggesting that you want to 
avoid 
>this solution at all costs.  I would seriously recommend that you DO 
use a 
>page-at-a-time subfile.  If a user needs to view 10,000+ records, it 
will 
>be a huge overhead on the system to load them all into a subfile and if 
the 
>file is continually updated by others, the information may be outdated 
by 
>the time the user reads it.  With a subfile of say fifteen records, the 
>response will be almost instantaneous and you can allow the user to 
>position-to anywhere in the list without having to read all the records 
in 
>between.  The change to the current code is really quite small and the 
>gains will be worthwhile.  I can send you a working skeleton of the 
>required code if you wish.
>To answer your question though, I would suggest applying all changes 
from 
>the current subfile, clearing it (SFLCLR), then re-building it from RRN 
1.
>Hope this helps,
>Regards,
>Alan Yates.
>
>----------
>From:  VANTALA AURIFULLAH[SMTP:aurif_v@hotmail.com]
>Reply To:      RPG400-L@midrange.com
>Sent:  08 March 1999 23:29
>To:    RPG400-L@midrange.com
>Subject:       Subfiles:Displaying 10,000th record
>
>Hi Friends,
>I'm doing Subfiles now.
>Apart from pagenated subfiles is there any other method to go past
>9999records.i've heard that we have to re initialize the RRN value for
>the 10,000 record,but in such a case won't we lose track of the first
>9999 records.A brief program (of that particular portion)will be of
>great help.
>Thanks in advance.
>Aurifullah.v
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
*
>* 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          
*
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
*
>
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
*
>* 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          
*
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
*
>

Get Your Private, Free Email at http://www.hotmail.com
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *