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 235

    Journal receive encryption

    After a discution with a Db2 expert about RCAC implemenation, it appears that after an update of a journalized table, the corresponding journal entry can be fully displayed with a simple DSPJRN command. Is it possible to add a new option at the cr...
    2 months ago in IBM i / Db2 for i 1 Not under consideration

    Db2 JSON functions for RPG data structures

    In some of the currently most used languages like Python and Node.js, it is common to define a data structure for your JSON payload, which is then easily transformed into JSON. In Python, we usually define a dictionary with all the fields and our ...
    2 months ago in IBM i / Db2 for i 4 Not under consideration

    Extend the SQL command HTTP_DELETE and include a additional body parameter

    It would be great if the SQL command HTPP_DELETE could be extended by an additional request body. I know that this is not the standard, but in an actual project we need to pass an order number in a HTTP_DELETE statement. The problem is, that other...
    3 months ago in IBM i / Db2 for i 2 Not under consideration

    New compile option for embedded SQL allowing to raise SQL errors as RPG errors

    Something like EXEC SQL SET OPTION SQLERRHANDLING = *EXCEPTION; that would allow a user to trap exceptions like this: monitor; EXEC SQL SELECT * FROM TABEL_THAT_DOES_NOT_EXISTS; on-excp [Whatevere error code for SQL error]; //Do something endmon;
    3 months ago in IBM i / Db2 for i 1 Not under consideration

    Allow ability to invoke Functions and Stored Procedures using Specific name in addition to Long Name.

    Currently Tables, Index and Views have the ability to invoke using either the long name or the short 10 character name. It will benefit for adopting both short and long names and stay consistent with Tables, Indexes and Views.
    3 months ago in IBM i / Db2 for i 1 Not under consideration

    Provide hash_row functionality to UDTF, Stored procedure that returns table, Cover all columns of a View over multiple tables.

    hash_row is an handy function to get hash/check sum value of the complete row. However there are exceptions. Expanding that benefit to all exceptions will be very helpful.
    5 months ago in IBM i / Db2 for i 1 Not under consideration

    Allow the evaluation of RPG expressions as "pseudo host variables" in EXEC SQL statements

    The idea is, to allow the evaluation of RPG expressions (including the call of %BIFs and procedures) inside an EXEC SQL statement as "pseudo-host-variables". The syntax could be like that: exec sql select count(*) into :myCounter from mytable w...
    6 months ago in IBM i / Db2 for i 3 Not under consideration

    Allow host variable for sql-json-path-expression in JSON_TABLE nested path clause

    In most of the JSON functions, I can use a host variable for the sql-json-path-expression argument. I cannot do that in a JSON_TABLE nested path clause, however. For consistency, I'd like to be able to use host variables for the sql-json-path-expr...
    6 months ago in IBM i / Db2 for i 1 Not under consideration

    Provide Db2 table / SQL Service to provide information on changed objects as seen in Memo to Users for new OS release.

    For each new release we review the list of changes made to APIs, SQL Services, Exit Points and Commands as recorded in the Memo to Users and then manually review these to see if our software uses any of these. For those that are used we then need ...
    7 months ago in IBM i / Db2 for i 1 Not under consideration

    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

    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.