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.

ADD A NEW IDEA

Db2 for i

    Showing 441 of 4961

    Basic subfile/maintenance generator for a given table_schema, and table_name

    We have UPDDTA to edit individual records of a file. We have RUNQRY for displaying all file records. It would save a lot of development time when we can have a default built-in subfile handler for any given table. => Shift F8, F9 to move subfil...
    over 1 year ago in IBM i / Db2 for i 1 Not under consideration

    cpyfrmimpf should handle commas.

    The cpyfrmimpf command handles values similar to 123.45 and -678.90 in a numeric field, but sends message CPF2845, reason code 7 for values like 1,123.45 or -1,678.90. The command should handle commas as well as decimal points and minus signs. Use...
    about 5 years ago in IBM i / Db2 for i 4 Not under consideration

    Allow column alias names in having clause

    Allow column alias names in having clause. Use Case: Excuse my bad english... When we use the having clause, we refers to a aggregate function of the select list. SELECT field, COUNT(*) AS counterFROM table GROUP BY field HAVING COUNT(*)>100 It...
    almost 8 years ago in IBM i / Db2 for i 4 Not under consideration

    Add parameters to QSys2.JobInfo, QSys2.Active_Job_Info and QSys2.Library_List_Info to accept a fully qualified job name.

    I need the ability to get a specific job's Library List. Not the current job.
    about 2 years ago in IBM i / Db2 for i 2 Not under consideration

    Add option for Cert path to qsys2.certificate_info UDTF

    not all certs are in the system store. some are stored in an IFS file. the API used in the UDTF allows for "Directory path and file name" . Add that as a option. Retrieve Certificate Information (QYCURTVCI, QycuRetrieveCertificateInfo) API - IBM D...
    about 2 years ago in IBM i / Db2 for i 3 Functionality already exists

    Allow COALESCE to provide automatic CAST

    I have this line in a CREATE VIEW statement: coalesce(va.vaaddress1, '?Unknown') as vaaddress1, When the view is accessed using SQL embedded in ILEPRPG, the SQLSTATE becomes 01004. VAADDRESS1 is defined in a SQL TABLE as CHAR(40). It would save a ...
    9 months ago in IBM i / Db2 for i 1 Not under consideration

    Prevent ALTER TABLE when field size expanded and there is a field procedure

    When a field procedure is assigned to a field, in our case for purposes of encrypting the field data, and an ALTER TABLE is allowed to execute against the field to expand the field size, then data corruption occurs. Use Case: Example Create table ...
    about 5 years ago in IBM i / Db2 for i 4 Not under consideration

    Add does-not-contain option in SQL Plan Cache Statements

    Access Client Solutions SQL Performance Center has a button "Show Statements..." that displays a "SQL Plan Cache Statements" window. You have a variety of filters, including "Statements that contain the following text". I think it would be incredi...
    over 3 years ago in IBM i / Db2 for i 1 Not under consideration

    Automatic Journaling of Access Paths

    When journaling is started on a library, you can created inheritance rules which will cause journaling to start on objects of type *file, *dtaara, and *dtaq. When indexes are created over tables the object gets journaled (type = *file) but not the...
    over 6 years ago in IBM i / Db2 for i 4 Not under consideration

    Allow variable number of arguments on SQL CONCAT function

    The current implementation of CONCAT only allows two parameters, for example CONCAT('hello', 'world') which makes concatenating multiple values cumbersome. This would for example result in CONCAT(CONCAT('hello', 'world'), 'again') for 3 strings. I...
    about 3 years ago in IBM i / Db2 for i 5 Not under consideration

    By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
    Do not place IBM confidential, company confidential, or personal information into any field.