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 238

    Add Function Usage for SQL Statements similar to Allowed SQL Statements in Query Manager

    Query Manager allows for limiting of SQL Statements, ALTER, DELETE, UPDATE, INSERT, etc. which is helpful to reduce the amount of users who can use SQL to manipulate tables. However, it only works within Query Manager. Can a Function Usage be adde...
    9 days ago in IBM i / Db2 for i 2 Not under consideration

    Make IFS_OBJECT_STATISTICS threadsafe

    I have a case where I am getting SQL State: 01H13 Vendor Code: 462 Message: [SQL0462] Procedure or user-defined function IFS_OBJECT_STATISTICS in QSYS2 returned a warning SQLSTATE. Cause . . . . . : An SQLSTATE of the form 01xxx was returned by th...
    15 days ago in IBM i / Db2 for i 1 Not under consideration

    Enabling an SQL query for the OVRFLW line of a spool file.

    It would be great if the OVRFLW line could be retrieved through an SQL query. With this attribute, spool files could be correctly duplicated from an application.
    about 2 months ago in IBM i / Db2 for i 2 Not under consideration

    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...
    3 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 ...
    3 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...
    4 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;
    4 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.
    4 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.
    6 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

    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.