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 Delivered
Workspace IBM i
Categories IBM i Access Family
Created by Guest
Created on May 26, 2022

Allow user to request more than 100 rows in Run SQL Scripts by default

Example: I am running a scan against the entire IFS for largest files. It takes 17-18 minutes or so to run. I can't ask for more than 100 results until after the 17-18 minutes. If I don't sit and watch it run, it closes the results before I can request the rest. I believe I can increase the timeout on the query but in my query I am limiting the results to 500. I would like a setting in ACS to increase the result set from 100 to in this case 500.

Idea priority Medium
  • Guest
    Reply
    |
    Apr 14, 2023
    This feature is in version 1.1.9.2 which is now available.
  • Guest
    Reply
    |
    Mar 29, 2023
    This is planned for our April 2023 update.
  • Guest
    Reply
    |
    Nov 18, 2022

    Hello,

    As long as the idea is not delivered, as a workaround adding "fetch first nnn row only" might help.

    Still the first 100 rows are shown by default, but scrolling down is possible until you reach the "nnn" limit. If you still want more the situation as described returns.

    Greetings,

    Rudi

  • Guest
    Reply
    |
    Jun 6, 2022
    Thank you for submitting your Idea to enhance IBM i Access Client Solutions (ACS). We understand the request and will consider it for a future update though no commitment is made nor implied. To prevent the results from being closed without having to watch, you can adjust the Run SQL Scripts timeout value at Edit-->Preferences, then select the Results tab and adjust the Minutes under the Activity section.

    IBM Power Systems Development