Re: Load all subfile

Hi!

if you only want to use load all technique only for some reason, you can
always load by setting the SFLSIZ to say 4000 and writing to the subfile
till it is full. If the user wants to see the next records then clear the
subfile and load again.

But the best approach is to use SFLSIZ=SFLPAG for the no. of records
considering the performance issues.

From: Mike.Collins@syan.co.uk
Reply-To: rpg400-l@midrange.com
To: rpg400-l@midrange.com
Subject: Re: Load all subfile
Date: Thu, 10 Oct 2002 10:54:04 +0100

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Well first of all, I feel sorry for your users having to wait whilst 13000
records are loaded to a subfile! This should be reprogrammed to a page at
a time subfile, the IBM guideline on when it was worthwhile to build the
whole subfile at once used to be if I remember correctly for less than 50
records, let alone 13000.

Without having two subfiles, one for the first 9999 records, and one for
the next x thousand, and conditioning which one is displayed with say an F
key, nothing immediately comes to mind if you persist with the load all
technique.




"MURALI DHAR" <nmuralidhar@rediffmail.com>
Sent by: rpg400-l-admin@midrange.com
10/10/2002 10:37
Please respond to rpg400-l


        To:     rpg400-l@midrange.com
        cc:
        Subject:        Load all subfile


I have a  requirment where iam using Loadall subfile...The no of
records Iam having right now is around 9000(less than9999)...Now I
have to add another 4thousands of records to this...I dont like to
reprogram it by using single page subfile...How can i do this with
Loadall subfile?Am I going to loose any records if i add 4
thousand records to the already existing 9000 records....I cant
reprogram it....I ve to do with Load all only....Can u please help
giving answer to this....
Best Regards
Murali.


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com