Subfile loading procedure

150 pts.
Tags:
AS/400
AS/400 Subfiles
LOAD ALL subfile
Hi ,

I am new to as/00 .I have a doubt in the loading procedure between load all and page-wise?

ASKED: March 9, 2011  10:53 AM
UPDATED: March 12, 2011  4:15 AM

Answer Wiki

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

Best practice is to loade a page at a time.
That reduces execessive I/O which will give you better performance.

Discuss This Question: 8  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
  • Kaisersosa
    Of the 3 subfile methods - 1. Load-All Subfile Method 2. Expanding Subfile Method 3. Single-Page Subfile Method I've been using #2 almost exclusively for years and it's handled everything I've been asked to do. My recommendation is to use #2 or #3 and ALWAYS use that same method. (if possible) It's just easier than jumping around between different methods. My 2 cents. John B
    245 pointsBadges:
    report
  • Runelf
    Of the 3 subfile methods - 1. Load-All Subfile Method 2. Expanding Subfile Method - (or Page+1) 3. Single-Page Subfile Method It depends: I use #2 most of the time. The ability to roll back without I/O is a great performance plus over #3. I only use #1 if the number of data records is small and no growth is expected such as a subfile of the US state codes.
    40 pointsBadges:
    report
  • pdraebel
    To me the #2 method has always worked fine. I cannot recall ever having to use any other method in my carreer.
    2,380 pointsBadges:
    report
  • assa
    Thanks. Please apologies.I think i was not clear on my question. in case of load all For eg, PF has 100 records sflsiz=20 and sflpag=5 here all 20 records are loaded at a time and 5 records are displayed at once on the screen In case of expandable, if PF =100 recrds sflsiz=10 sflpag=9 here records are loaded page by page.so at a time 9 recods are displayed on the screen.so what is the role of sflsiz here?
    150 pointsBadges:
    report
  • Runelf
    In both of your examples, the subfile is loaded by the subfile size. It is displayed by the subfile page. 1. Your first example (our 1. Load-All Subfile Method) loaded 20 records (to be truly Load-All your subfile size would be 100), then displayed the first 5. A roll down would not need a loading of any additional until you roll to the fifth page. A roll up or down withing the 20 will not require any additional I/O of the database. 2. In your second example(our 2. Expanding Subfile Method - (or Page+1)) you load 10, display 9. The 'More...' will display because of the 10th record in the subfile. When you roll down you will add the next 10 records and display records 10-18, still displaying 'More...'. A roll up to the prior page will not require any I/O. 3. For our example 3. Single-Page Subfile Method (page=10, size=10), you would be re-initializing and loading the next 10 records on every roll up and down. Remember the subfile records are loaded into memory. So you design the right subfile according to how it is used. What is the size of the file, memory considerations, how does the user need it displayed. Will he need to roll up/down a lot? Will he always find the record on the first page, or have to roll several pages back and forth to view what he is looking for??
    40 pointsBadges:
    report
  • assa
    Thank you very much
    150 pointsBadges:
    report
  • TomLiotta
    so what is the role of sflsiz here? The role of SFLSIZ is to set the amount of memory that the job will initially allocate to hold subfile rows. Your two examples -- sflsiz=20/sflpag=5 and sflsiz=10/sflpag=9 -- are logically the same. Both can be used as Load-All or as Expanding subfiles. The only requirement that makes a subfile be a Page-At-A-Time subfile is that SFLSIZ is equal to SFLPAG. Both of your examples are unequal. In short, a Load-All subfile simply means that your program has written all the rows it's going to write; the system will not ask for more. An Expanding subfile means that the system can ask your program to add more rows. Both of those types depend on your program logic, and both types are possible any time SFLSIZ is greater than SFLPAG. Tom
    125,585 pointsBadges:
    report
  • assa
    [...] Assa was in search of a subfile loading procedure, and Runelf provided an approval-worthy [...]
    0 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