Subfile Limit

390 pts.
Tags:
AS/400 Subfiles
Subfile Control
Subfile Size
Hi I am doing an inquiry on the GL and because of our normal monthend date 21/12/10 - 05/02/11, it come up with a message of "number of subfile records has reached the allowable size limit" How can I chage this? On the subfile I have SFLSIZ(0240)

Answer Wiki

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

If your getting that message it is because you are trying to read too many records before displaying the subfile.
You should only read enough to fill a pagbe at a time.
If you do a search for subfile in this database, you will find many answers on how to resolve your problem.
There is no need for us to post the same solution mulitiple times.

Discuss This Question: 3  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
  • TomLiotta
    The subfile limit is 9999 rows. Since you really shouldn't be putting more than a couple hundred rows into a subfile, the 9999 limit shouldn't be a problem. Use the page-at-a-time method if you need to handle more than 9999 rows. This is discussed in the Information Center topic Example: A subfile with paging by i5/OS and high-level language program, and many other places. In short, no, you can't have a subfile with more than 9999 rows. Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    On the subfile I have SFLSIZ(0240) The SFLSIZ() attribute performs one of two possible functions. If it has the same value as the SFLPAG() attribute, it sets the subfile as a page-at-a-time subfile. The subfile will hold only as many rows as will fit on the page. If it is larger than SFLPAG(), then it is a load-all subfile and the limit is 9999 rows. The SFLSIZ() value is used to allocate memory after the display file is opened to hold that many subfile rows. If you continue to add more rows, additional memory allocations are made in order to hold the added rows. Tom
    125,585 pointsBadges:
    report
  • Modiyooch
    quick and dirty fix to existing program to avoid a systems msg is to check the index value while building subfile and at 9995 display what you have with an informational type message for user to narrow the selection.
    540 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