Position to in subfiles

140 pts.
Tags:
AS/400
AS/400 Subfiles
Subfile
Subfile type -Load All
SFLRCDNBR(cursor)
If I mention * top also as parameter in SFLRCDNBR, when I take option against any row nd return to initial screen, the selected row will be displayed as first row in the page. So I prefer using cursor as the parameter of SFLRCDNBR as it always points to the first record in that page and cursor points to the record I have previously actioned by using option 2,5 etc. However I have a position to in my SFLCTL where in when I give the value, it should read the subfile and position to from that record onwards. Without using *top, only cursor is pointing to the filtered value, whereas it is not coming as the first record in that page. Is there any option to display it as the first record in the page without using *top in Load al subfile?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • GregManzo
    Load-all subfiles are a *really* bad performance hit for a large file. Better is to use an 'extending' subfile. A 'position to' key starts building the first page from that point in the DB, then when user hits PgDn you add one more page to the SFL. That way you only wear the performance hit for the records they see on screen.
    We built all this logic into a standard /COPY used by all Work With type screens - mainline is in /COPY, pgms are now a few subroutines called from /COPY to do things like load specific key fields, fetch descriptions for display, filter records, etc.
    2,960 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: