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 230

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.
about 1 month 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.
3 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...
3 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...
4 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 ...
5 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 ...
7 months ago in IBM i / Db2 for i 1 Not under consideration

Moving old data from production tables to historic tables in another library

In an active production system such as we have being in a 24 hour service financial environment, we have an issue with old data that exists in many of our database tables. Every second new data is being recorded in this tables and old the old data...
7 months ago in IBM i / Db2 for i 3 Not under consideration

Tools do assist with Spatial/GIS data on DB2 for i

When dealing with spatial data, it is quite common to use tools and/or products that assist in the manipulation and loading of this data. Even within the DB2 family (LUW and z/OS), there is the DB2 Spatial Extender which enables the import and man...
8 months ago in IBM i / Db2 for i 1 Not under consideration

Add SIRGAS 2000 as supported datum on DB2 for i

Since 2005, Brazil has adopted datum SIRGAS 2000 as its official Georeferencing System. Therefore, all information exchanged between government entities must adhere to this standard. It is also used by other Latin American countries. Thus, it woul...
8 months ago in IBM i / Db2 for i 2 Not under consideration

SQL Update using Common Table Expresions

Currently an UPDATE statement that attempts to update a field with the selected value from a Common table expression causes an SQLCODE -199 with SQLSTATE 42601: "Illegal use of KeyWord UPDATE. Token ( SELECT VALUES was expected" --or something sim...
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.