AS/400: exceeding 9999 records in load all subfile?

165 pts.
Tags:
AS/400 Subfiles
My question : I am using a load all subfile.Now when the records exceed 9999 records,(for example the page i am visting is the 9999th record page),what will happen if i press page-up. And will the subfile give error if i load this file with 9999+ records ?

How to handle the page-up & down in this case of load-all?



Software/Hardware used:
AS400
ASKED: January 12, 2010  10:34 AM
UPDATED: January 15, 2010  2:00 AM

Answer Wiki

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

I always just put 1500 in that field. My theory is a user is not going to scroll down and look at all those records. So put a search in the subfile for 2 reasons. Faster response and user friendly..
Ron

Discuss This Question: 9  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
  • ReshmaG
    Hi First thing is that u can't load more than 9999 at a time at all. and this is the limitation in Load all subfile If u need to do that u need to use Single page Subfile where u need to handle Page Up and Pagedown. Please check out the link for the Subfiles http://osdir.com/ml/lang.as400.rpg/2002-11/msg00196.html Regards Reshma
    455 pointsBadges:
    report
  • Supriyob2
    I know the constraint...but my quetion was: what will happen if there are 9999+ records in a PF and i am using that file in load-all SFL. will it only show till 9999 or after that it will abend?
    165 pointsBadges:
    report
  • ReshmaG
    No matter how many records are there in a PF but for load all u can load only 9999 max.. i.e. in the Subfile u need to mention SFLSIZ = " Number of records u want to load " it will load at a time 9999 only u can'tgive more than 9999
    455 pointsBadges:
    report
  • DLM2007
    Recompile the the physical file's initial records to *NOMAX. The default is 10,000
    280 pointsBadges:
    report
  • Teandy
    I believe that the program will abend when loading the subfile and I know for certain that the program will abend if you try to page down past the 9999th record. If I were doing this, I would use either a page at a time subfile or a load all that holds between 1500 to 2500 records. Both would have a search field to set where the subfile starts to read the PF.
    5,860 pointsBadges:
    report
  • Littlepd
    Assuming you've coded your program to catch the error you are going to receive when you try to write record # 10,000 to your subfile then continue on to display the subfile, you will get a warning message on the screen when you reach the end of the subfile. You will not be able to scroll past that last page. As for how to handle the page keys in this case, you can't. Load-all subfile don't let you handle page keys, they handle them for you. Control is never returned to your program for you to even know that a page key was pressed. If you want to have a subfile that displays that many records from your file, it cannot be a load-all subfile. You must make it a page-at-a-time subfile. That means handling all of the page keys that are pressed, not just the last one, and you must load each page every time a page key is pressed.
    1,130 pointsBadges:
    report
  • Vatchy
    If you expect that a user will need to scroll through more than 9999 records then you need to use a SFLSIZ = SFLPAG+1 subfile and include a position-to field in the display file so that the user can do instant positioning rather than having to scroll that many pages. Also, loading 9999 records before showing the subfile to the user will cause a significant delay.
    1,410 pointsBadges:
    report
  • TomLiotta
    Minor correction -- it would be a SFLSIZ = SFLPAG subfile, a page-at-a-time subfile where the size is defined equal to a single page. For the question, the number of records in a PF is not related to the number of records in a subfile. A subfile will only hold what you successfully write to it. You can try to write more than 9999 rows to a subfile, but the next write won't succeed. I think it will result in a simple error with status 00013. (It's probably been 20 years since I've seen any attempt to write that many rows. There is no point to having 500+ pages to scroll through in a subfile.) Tom
    125,585 pointsBadges:
    report
  • Vatchy
    The important point in my post was the "position-to" information. That is useful to allow the user to avoid having to scroll through 9999 records. Just use the position-to info to SETLL and start the subfile from there.
    1,410 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