RE: RPGLE DDS Subfile out of 9999 records limit

Yes, I agree. In situations like this, it's good to know what the users
are doing with the data. Not knowing anything, perhaps it's better to
load a subset of the data based on some criteria? We occasionally used
Global temporary tables to load a data set into, and then display in the
subfile from there. Then, allow sorting on the various column headers
so the records could be ordered in meaningful ways. This meant that
depending on the ordering, you could see the end of the data set or the
beginning, but never really all of it in one subfile. You can do that
by resetting the subfile when you max it out, but if records can be
selected all the way through, that's probably not the best answer.

Mark

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Friday, September 07, 2007 1:29 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: RPGLE DDS Subfile out of 9999 records limit

Hi J Z
I'm curious as to why you state that you HAVE to load ALL 30,000 records
into the subfile.
Answering this question may present an opening for people to give you
different suggestions



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

rpg400-l-bounces@xxxxxxxxxxxx wrote on 09/07/2007 04:24:44 PM:

Hi,

As you know that IBM restricted to the 9,999 records limit when load a

subfile, and we can just load one page at a time to not limited by the

number of records.

But I have a situation that need to load all data (almost 30, 000

records)

into subfiles, and allow user to do page down, page up to
select/change multiple records. I can do the page down & page up, but
how can I get my selected data 'cause the original SFLRCDNBR can only

up to 9999 ?

Any hints, suggestions or sample codes would be really appreciated!

JJ
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.

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