AS/400

2380 pts.
Tags:
Subfiles
When and Where do we need to use a load all Subfile, load on equal Subfile?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Regarding BigKat’s answer, if you allow “position to” on the SFL, PAAT is better because they you can allow Page Up, if the user has positioned past where he wanted to start,

Discuss This Question: 4  Replies

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BigKat
    you use a subfile to display multiple related records, such as line items on a purchase order.  A subfile can only contain 9999 records, so if you have more than that you need to do page-at-a-time (PAAT) subfiling and control populating the screen with the correct next/prior set of data.  In reality, no one would want to look through 9999 records, so you would want to do PAAT much sooner.  Load-All subfiling is appropriate when they are a relatively few set of records, such as a prompt list of reason codes for why the user wanted to cancel a line item on their purchase order.
    8,060 pointsBadges:
    report
  • TomLiotta
    Regarding the question, it is never necessary to use a load-all subfile. The major reason that a load-all subfile is used is simply because it is easier to program.   Any of the usual uses of subfiles can be done with any of the subfile types, including "Position to" and page-up/page-down although the subfile might need to be reloaded to make it look as if it's happening naturally.   Tom
    125,585 pointsBadges:
    report
  • Sureyz
    so, Page-at-a-time(PAAT) subfile will have a better performance when compared with other two i hope.ThanksSurey. 
    2,380 pointsBadges:
    report
  • TomLiotta
    Page-at-a-time(PAAT) subfile will have a better performance...   Usually performance has essentially no relationship to subfiles. One type of subfile will probably be indistinguishable from the others in terms of performance.   Tom
    125,585 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following