Re: Load all subfile

["rajan tangri" <rajantangri@xxxxxxxxxxx>]

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