Subfile Limit
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)
Software/Hardware used:
Software/Hardware used:
ASKED:
February 7, 2011 7:36 AM
UPDATED:
February 15, 2011 7:53 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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
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
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.