× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. December 2005

Re: Updating a Program using SETLL/READPE - Suggestions

Hi Brian, For one thing, you are testing indicator 99 twice. This is double the work. Also, you could change the update to exception output so that only the three fields are being updated. The code would look something like this: 
setll
reade 
*In99 doweq *off
moves
except
reade
enddo Glenn Gundermann Brian Piotrowski writes:
Hi All, 
We have a PF that has over two million records in it (and it grows
daily), that uses a SETLL/READPE command.  I know there has been much
debate as of late on the use of these commands, and I wanted to present
a bit of could for your perusal and suggestions.  Right now, the system
is very slow at updating records (sometimes in excess of five minutes),
and I suspect it has something to do with this code: #SRUPD BEGSR TIME TIME6 6 0 *(SST22) KEYT22 SETLL SST22 *IN99 DOUEQ *ON KEYT22 READE SST22 99 99 LEAVE MOVE '1' SRADNF 
                   Z-ADD     *DATE         SRADDT
                   MOVEL     TIME6         SRADTM
UPDATE RSST22 ENDDO

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.