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

Db2 for i

Showing 360

Enhance Omnifind product or integrate it with base db2 for i

OMNIFIND is a text search product that allows IBM i users to search unstructured text stored in a column of a DB2 for i table. The text stored in the column can be either simple character text, an XML document, or any of several different types of...
6 months ago in IBM i / Db2 for i 1 Future consideration

SQLRPGLE precompiler - allow usage of large VARCHARS by interpreting the same as SQLTYPE(CLOB)

Currently you cannot use large RPGLE VARCHARs (length >= 32705) in EXEC SQL statements. I suggest updating the SQL precompiler and SQL processing so that they can be. This would remove the need for defining SQLTYPE(CLOB) in new programs, VARCHA...
9 months ago in IBM i / Db2 for i 1 Future consideration

Add ability to use any RPG variable in an embedded SQL statement, including those that come from Qualified Dimensioned data structures

Programmers would benefit by not seeing the error - Variable :BLAH is not usable for reason X when writing exec SQL select statement in an RPG program. Some variables are allowed and some are not, but it is not always clear why this basic select d...
about 1 month ago in IBM i / Db2 for i 1 Not under consideration

Allow multiple Recipients in the send email function

Absolutely love that we now have send email, however the usability would grow if we could email multiple recipients. suggestion would be to have recipients septerated with a semi colon or comma.
6 months ago in IBM i / Db2 for i 2 Future consideration

SQLRPGLE precompiler - SQLTYPE(CLOB:x) to VARCHAR instead of to DS

Add a d-spec and/or ctl-opt keyword to instruct the SQL precompiler to convert SQLTYPE(CLOB:x) (and BLOB etc.) to VARCHAR(x:4) instead of the UNS(10)/CHAR(x) DS that it currently converts to. // Thisdcl-s myVar1 SQLTYPE(CLOB:X);// Pecompiles to th...
9 months ago in IBM i / Db2 for i 1 Future 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...
almost 2 years ago in IBM i / Db2 for i 6 Not under 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...
2 months ago in IBM i / Db2 for i 3 Future consideration

Include non externally described files info in the SYSPARTITIONSTAT sql view

I'm using the qsy2.syspartitionstat function to analyze physical files info, like sizing, number of members, info change dates, and others. I find it really easy to use and has a great functionality. But I was surprised that it doesn't consider th...
2 months ago in IBM i / Db2 for i 2 Future 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...
over 1 year ago in IBM i / Db2 for i 4 Future consideration

Allow partitioning of DDS created tables

As of today, a DDS created table cannot be partitioned by ALTER TABLE ADD PARTITION. In many cases, a DDS table can be converted to an SQL table, however some keywords like DATFMT are not available in SQL. Which means that those tables cannot be c...
4 months ago in IBM i / Db2 for i 1 Not under consideration