Re: Logical by date problem

If speed is a concern and you don't want to be limited to only two months
of data, I suggest changing the program to be page-at-a-time load.  So what
you'll do is... If you have 14 lines per display... just load the first 14
records, wait for the page down event and load the next 14 records... etc.
If page up, load previous 14 records.  Using a logical by date will allow
you to start the program two months ago if you like, but it still leaves
the possibility for the user to page up and go further back.

Michael Schutte



                                                                           
             steema@diskhaven.                                             
             com                                                           
             Sent by:                                                   To 
             rpg400-l-bounces@         "RPG programming on the AS400 /     
             midrange.com              iSeries" <rpg400-l@xxxxxxxxxxxx>    
                                                                        cc 
                                                                           
             06/06/2006 08:27                                      Subject 
             AM                        Logical by date problem             
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




HI I have a subfile program looking at EDI data, masses of it. I built a
logical file, but the data load was too large. I was told to Select on the
date starting from this past May so of course it loads straight away. I
was told to build a small program to mark the EDI records so that I will
only be loading 2 months or so. Now there must be a better way to do this?

I am thinking of embedded SQL in the RPG program. Is this the preferred
method?

Thanks,
Steve
--
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.