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.

ADD A NEW IDEA

FILTER BY CATEGORY

Db2 for i

Showing 296 of 3804

Add an ANY_VALUE aggregate function

Please add an ANY_VALUE aggregate function, this would simplify queries that group by an id and also require other values that are known to be unique within the group. SELECT a.article_id, ANY_VALUE(a.description), COUNT(*) FROM article AS a JOIN ...
about 1 hour ago in IBM i / Db2 for i 0 Submitted

Add view or udtf JOB_QUEUE_ENTRIES

Because the view JOB_QUEUE_INFO already exist, so similar to the output_queue_xxx views the job_queue_entries view is missing select * from qsys2.job_queue_entrieswhere job_queue_name = 'QBATCH'
25 days ago in IBM i / Db2 for i 1 Submitted

Allow stored procedures created as *PGM objects to be called as exit point programs

When using the CREATE PROCEDURE SQL statement to create a *PGM Object it is NOT possible to call the generated object outside of SQL; doing so results in an error reporting "Pointer not set". Looking at the code generated as an intermediary step i...
9 days ago in IBM i / Db2 for i 0 Submitted

provide readable format when consuming .xlsx using qsys2.ifs_read

Functionality will eliminate having to save xlsx as a csv prior to consuming with qsys2.ifs_read
about 2 months ago in IBM i / Db2 for i 2 Future consideration

Enhancements to RPGLE SQLTYPE

I would like to be able to define an SQLTYPE field as a TEMPLATE. I would also like to be able to use a named constant for the SQLTYPE size parameter. An example: dcl-c $len_rcCLOB 2000000; dcl-s t_rcCLOB sqltype(CLOB: $len_rcCLOB) template; dcl-s...
about 1 month ago in IBM i / Db2 for i 2 Future consideration

Require QIBM_DB_SECADM or similar to perform set session authorization

Today any user with *ALLOBJ is able to do the equivalent to sudo in Linux without the need of any password to become another user using set session authorization via SQL. Any user with *ALLOBJ can become Qsecofr by open strsql and run: “Set sessio...
6 months ago in IBM i / Db2 for i 5 Not under consideration

Implementation of restore function that does not change the state of the access path

We would like you to implement the restore function that does not change the state of the access path by implicitly shared access paths. Our customers are having trouble getting their program to do something unexpected by save and restore. We wou...
12 months ago in IBM i / Db2 for i 6 Not under consideration

UUID datatype for IBMi

A UUID is a Universally Unique Identifier, meaning that these identifiers are unique over your whole DB; even better unique" across space and time". UUID's are stored in 128bit format and follow a standarized format (rfc4122) This makes the type a...
7 months ago in IBM i / Db2 for i 4 Future consideration

Add the "Share Open Data Path" attribute to the QDBRTVFD API

The SHARE ODP attribute is missing from the QDBRTVFD API. While SHARE is technically a file's MEMBER attribute, it is an attribute that is pervasively associated with a file object. Currently there is no user-accessible way of retrieving that attr...
28 days ago in IBM i / Db2 for i 0 Submitted

change RESPONSE_HTTP_HEADER for QSYS2.HTTP_GET_VERBOSE when we want cookie

The HTTP functions do not handle the multiple use of the "set-cookie" headers within an HTTP response. The root issue is that JSON keys should be unique and multiple instances of the "set-cookie" key are not permitted in JSON. Here is a possible a...
3 months ago in IBM i / Db2 for i 1 Future consideration