Re: RPGLE DDS Subfile out of 9999 records limit

[Karen L Hodge <khodge@xxxxxxxxxxx>]

We use attachmate here and none of the enhanced keywords are supported.
: (



Karen Hodge
Senior System Analyst
Genesys Health System
1000 Healthpark Blvd, Grand Blanc, Mi 48439
Office 810.606.5180, Fax 810.606.7204
khodge@xxxxxxxxxxx


                                                                           
             rpg400-l-request@                                             
             midrange.com                                                  
             Sent by:                                                   To 
             rpg400-l-bounces@         rpg400-l@xxxxxxxxxxxx               
             midrange.com                                               cc 
                                                                           
                                                                   Subject 
             09/09/2007 01:00          RPG400-L Digest, Vol 6, Issue 900   
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             rpg400-l@midrange                                             
                   .com                                                    
                                                                           
                                                                           




Send RPG400-L mailing list submissions to
             rpg400-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
             http://lists.midrange.com/mailman/listinfo/rpg400-l
or, via email, send a message with subject or body 'help' to
             rpg400-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
             rpg400-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of RPG400-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

   1. A:  RPGLE DDS Subfile out of 9999 records limit (Carlos A Ramirez)
   2. Re: RPGLE DDS Subfile out of 9999 records limit (Booth Martin)
   3. RE: RPGLE DDS Subfile out of 9999 records limit (Joe Pluta)
   4. Re: RPGLE DDS Subfile out of 9999 records limit (Booth Martin)
   5. Re: RPGLE DDS Subfile out of 9999 records limit (Pete Helgren)
   6. Re: RPGLE DDS Subfile out of 9999 records limit (Simon Coulter)
   7. RE: RPGLE DDS Subfile out of 9999 records limit (Joe Pluta)


----------------------------------------------------------------------

message: 1
date: Sat, 8 Sep 2007 08:40:31 -0700 (PDT)
from: Carlos A Ramirez <asapltda@xxxxxxxxx>
subject: A:  RPGLE DDS Subfile out of 9999 records limit

EXISTEN 2 FORMAS DE HACER LO PRESENTADO Y DEPENDEN DE
COMO LO HACE EL USUARIO
1.............................................
SET POSITION  THE DATABASE
LOOP:
  INZ SFL
  READ NEXT 100 RECORDS
     SHOW SFL
     USER CHABGE SFL
     REVIEW CHANGES
     WRITE CHANGES TO DBF
   GOTO LOOO

2 ........................
SET POSITION  THE DATABASE
LOOP:
  INZ SFL
  READ NEXT 100 RECORDS
     SHOW SFL
     USER CHABGE SFL
     REVIEW CHANGES
     WRITE TEMPORAL FILES THE CHANGES FROM SFL
     GOTO LOOP

2A READ TEMPORAL FILE
   WRITE CHANGES TO DATABASE

SULUDOS DESDE COLOMBIA


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!



Carlos A Ramirez
Telefono 664.71.40 Movil 310.515.93.60
Desarrollador de Software AS400 DELPHI