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

My ideas: Db2 for i

    Showing 174

    Multi-row insert in dynamic SQL RPG

    Please enhance dynamic SQL support in RPG to include multi-row insert. Use Case: Dcl-DS myQualDS ExtName('THETBL') Dim(200) Qualified Inz; End-DS; myQualDS (1).dta = '1'; myQualDS (2).dta = '2'; Ctr = 2; SQLStatement = 'Insert into THETBL ? rows v...
    over 7 years ago in IBM i / Db2 for i 2 Future consideration

    Query Supervisor: Update ADD_QUERY_THRESHOLD procedure to add filters to restrict or allow users by Gruop Profiles

    Update ADD_QUERY_THRESHOLD procedure to add filters to restrict or allow users by Gruop Profiles. I think this capability can be enhanced add INCLUDE_GRPPRF and EXCLUDE_GRPPRF to allow more filters when we have the user profiles organized by Group...
    almost 2 years ago in IBM i / Db2 for i 3 Future consideration

    Allow manually deleting Db2 temporary indexes

    Now that we have QSYS2.MTI_INFO and its visibility into DB2 temporary indexes, we are trying to clean them up and manage them better. We only IPL every 3 to 4 months. We created permanent indexes to replace a lot of temporary indexes, but they app...
    8 months ago in IBM i / Db2 for i 1 Future consideration

    Adding a new activation group parameter to CREATE or REPLACE VARIABLE

    A C-ILE program is currently being created at CREATE VARIABLE, which runs with the activation group *CALLER. Therefore, the SET VARIBALE VALUE can only be used in the activation group in which the variable is used. By specifying a named activation...
    over 1 year ago in IBM i / Db2 for i 2 Future consideration

    Allow variables defined with like(<file-field>) to be used as embedded SQL host variables

    If a variable in RPGLE is defined with like, and the source field comes from an external file (PF, DSPF, etc), the SQL preprocessor does not like it. Example: dcl-f CUSTMAST keyed; dcl-s qCust like(CUSTNUM); // CUSTNUM defined in CUSTMAST If I att...
    about 2 years ago in IBM i / Db2 for i 3 Future consideration

    Support *LIBL on RUNQRY QRY()

    Hi, When creating a query definition, the library is resolved at creation time and not at runtime. This method is unlike any other function on IBM i and doesn't allow the query to be used with another library list as it is ignored. This way you ca...
    over 3 years ago in IBM i / Db2 for i 3 Future consideration

    API for Access Path Rebuild Progress

    We commonly have access path rebuilds occurring post the vary on of an IASP. We would like the capability to monitor the progress of the access path rebuilds from a batch job rather than just the screen. Use Case: We run a superannuation system on...
    over 8 years ago in IBM i / Db2 for i 8 Future consideration

    Add optional argument for XMLPARSE

    To use XMLPARSE, the external encoding of the data need to be consistent with XML prolog. But, often, the encoding of the variable (in hosted langage or CLOB) isn't the same as original value. For example : when we receive an XML file by FTP or ot...
    over 3 years ago in IBM i / Db2 for i 1 Future consideration

    Need SQL Procedures to allow the ownership to be changed and to allow the use of adopted authority

    We would like to have an SQL statement way of changing the ownership of a stored procedure. The TRANSFER OWNERSHIP SQL statement does not support stored procedures.In addition, there needs to be a SQL statement way of allowing a stored procedure t...
    over 7 years ago in IBM i / Db2 for i 2 Future consideration

    get_xml_file() need to be encoding agnostic

    The get_xml_file() is a fantastic tool to load XML files from the IFS. However it will fail if data is stored in utf-16LE format.
    about 3 years ago in IBM i / Db2 for i 1 Future 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.