Skip to Main Content
IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Not under consideration
Workspace IBM i
Categories Core OS
Created by Guest
Created on Mar 28, 2017

The limit of 9999 records in a subfile is more than 30 years old. Time to increase

There is some justifcation about the limit of 9999 for a subfile. It is more than 500 pages. To roll so many pages does not make sense.

But many have desinged programs that search subfiles, sort the subfile, print the subfile,
see also request https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=102953

Therefore big subfiles are useful even if the user cannot reach to the end of the subfile.

Maybe the limit should be 999,999,999 records.


Use Case:

When the subfile reaches 9999 records it crashes the program. The limit is way back in the old S38 days.


Idea priority Medium
  • Guest
    May 2, 2022

    This is an old RFE and should probably be purged. The code for Subfiles goes back to the late 1970s (at least 45 years) and the likelihood of it being changed now is 0 (more chance of it breaking thatn being enhanced). No one is brave enough to touch that code. the recommendation use page at a time subfiles has been there since S/38 was released. (Don't know what the OP meant about s/36 that hobby computer never had subfiles.) Anyway, with the new LIMIT and OFFSET in SQL SELECT statements, doing page at a time subfiles has never been easier so there's little need for this feature except in cases where a legacy app's data is growing with time. then yes it is needed, but still not justified.

  • Guest
    Oct 3, 2017

    IBM does not plan to implement this request at this time.

  • Guest
    Jul 18, 2017

    Green-screen applications will never go away and the CAAC thinks that programmers should focus on business problems and not operating system limitations.

    The CAAC has reviewed this requirement and recommends that IBM view this as a medium priority requirement that should be addressed.

    Background: The COMMON Americas Advisory Council (CAAC) members have a broad range of experience in working with small and medium-sized IBM i customers. CAAC has a key role in working with IBM i development to help assess the value and impact of individual RFEs on the broader IBM i community, and has therefore reviewed your RFE.

    For more information about CAAC, see www.common.org/caac

    For more details about CAAC's role with RFEs, see http://www.ibmsystemsmag.com/Blogs/i-Can/May-2017/COMMON-Americas-Advisory-Council-%28CAAC%29-and-RFEs/

    Dawn May - CAAC Program Manager

  • Guest
    Apr 21, 2017

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Servers and Systems Software
    Product family - Power Systems
    Product - IBM i
    Component - Core OS
    Operating system - IBM i
    Source - None

    For recording keeping, the previous attributes were:
    Brand - Servers and Systems Software
    Product family - Power Systems
    Product - IBM i
    Component - Languages - RPG
    Operating system - IBM i
    Source - None

  • Guest
    Mar 30, 2017

    Matt_Tyler wrote: "Its time to write page at a time loading sub files"/

    This is an option. In the old S36 days there wre no subfiles at all and the prgrammers did a great job rolling back an forth the screens. It wa fantastic, at tha time.

    But thi it was not object oriented. In the object oriented structure, the Operating System does the job of rolling back an forth the screen-subfile, while the programmers are concentrating on the buisness part of the logic. It makes also the code much shorter, standard and easier to maintain.

  • Guest
    Mar 29, 2017

    Its time to write page at a time loading sub files and stop complaining about the limit.