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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - 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 Jan 11, 2018

Run SQL Scripts - Autocomplete

Just like RDI or any else IDE you can autocomplete or look up fields when writing code. It would be great if this would be available in Run Sql as well and in best case it would also be able to handle a library list for those of us with multiple schemas (the one already defined in the connection).

Use Case:

Writing sql:
Select * from tab.. [user press ctrl+space and gets available tables starting with "tab"] selects tableA .
where [user press ctrl+space and get available fields from table in the select from tableA].

As with RDI / Eclipse you would also see field information in the drop down when you select a field/table during autocomplete.

Idea priority Medium
  • Guest
    Dec 9, 2019

    This is now available in our update.

  • Guest
    Nov 11, 2019

    This will be available in our next update.

  • Guest
    Apr 2, 2018

    I have wanted this for years and I would say it's a high priority. You're hoping to get younger developers on-board and they come in with auto complete from MSSQL and so forth and unfortunately they (and the rest of us) find a place where they'll spend a good portion of their time being frustrated and slowed down by having to have a secondary source for table names & field names. Without it, Run SQL scripts is hardly better than STRSQL:(

  • Guest
    Feb 7, 2018

    Under Consideration - IBM has received this requirement and is evaluating it. A response will be provided when evaluation is complete.

  • Guest
    Jan 18, 2018

    This functionality is sorely needed. SQL Server management studio is light years ahead of any SQL IDE I have used for the IBM i. If this could also be a plugin to RDI this would be a great plus.

  • Guest
    Jan 16, 2018

    The CAAC has reviewed this requirement and recommends that IBM view this as a high priority requirement that is important to be addressed. ACS should strive to provide function similar to other modern SQL tooling, such as Squirrel.

    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

    For more details about CAAC's role with RFEs, see

    Dawn May - CAAC Program Manager