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 Future consideration
Workspace IBM i
Categories IBM i Access Family
Created by Guest
Created on Apr 8, 2026

Allow Copy of Table Column into Run SQL Scripts Statement

I would like to be able to right click on a column heading and select "Copy Column Name to SQL". When building an SQL statement, I often don't remember the column names and will run a "select * from" to get all the columns. In some cases (look at a lot of the QSYS2 tables), the column names are long and hard to key in. I have to carefully type in the column name when it's right there on the screen in front of me. Alternately, using the "Columns.." view and being able to drag the column name into the SQL statement would be extremely helpful, too. Being able to do this would be a great productivity improvement by increasing the accuracy of the column name and the reduction in typing time.

Idea priority Low
  • Guest
    Apr 16, 2026
    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.

    Consider using the "Details..." action on the results, which displays a dialog with information about the results, including column meta data.
    The Column details grid supports multiple selections, and provides menu options for copying the column name.

    IBM Power Systems Development
  • Guest
    Apr 9, 2026

    I do not really have any objections regarding this request, but I am curious why you do not utilize the content assist (prompting) feature in ACS Run SQL Scripts? To me the content assist is the most superior way to building an SQL statement without knowing the column names.

    Just write the following SQL statement for a schema and table that exist and position the input cursor between select and from and press either Shift - Space or use the F4 key and you will get a list of available columns to choose from:
    select from myschema.mytable;