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

Add Support for the CTLCHAR parameter of the CPYSPLF Command to the SPOOLED_DATA Function

The SPOOLED_DATA function is a simple wrapper for the CPYSPLF CL command. However it offers straight printer output but no spacing/skipping control options. Add a parameter to the function that accepts the *FCFC, or *PRTCTL options. It would be gr...
3 days ago in IBM i / Db2 for i Submitted

Support extended simple case expressions

It would be nice if the extended simple case expressions introduced with SQL:2003 were supported. CASE colWHEN 'A', 'B' THEN 'open'WHEN 'C' THEN 'done'ELSE 'unkown'END CASE colWHEN < 10 THEN 'low'WHEN < 50 THEN 'medium'ELSE 'high'END This wo...
14 days ago in IBM i / Db2 for i Submitted

DB2 for i - Add Function RENAME COLUMN to Rename name column

In DB2 SQL, create the RENAME COLUMN function to rename a column.This DB2 SQL function is supported in other environments (DB2 for Linux, UNIX, Windows, and z/OS).
17 days ago in IBM i / Db2 for i Submitted

Edit option in ACS not available

Hello,As you can see in the attached image (as an example), it's not possible to edit files through ACS. Being able to edit files directly would be very helpful.Currently, to edit a file, you have to download it, use a text editor, and then upload...
18 days ago in IBM i / Db2 for i Submitted

Enhancement request: Add option to QSYS2.PTF_INFO to return all known PTFs, including PTFs for non-installed product options

Please enhance the QSYS2.PTF_INFO SQL service to optionally return all PTFs known to the system, including PTFs related to product options that are not currently installed. Today, QSYS2.PTF_INFO only returns PTF information for installed products/...
21 days ago in IBM i / Db2 for i Submitted

Incorporate the SQL_ERROR, SQL_WARNING, and SQL_NOT_FOUND indicators into SQLCA

Incorporate indicators into SQLCA so that the code in SQLRPGLE is much clearer when validating SQL statements, without having to deduce it every time we read conditions involving sqlcode, sqlstate or sqlwarn. Wanted SQL_SUCCESS SQL_NOT_FOUND ...
29 days ago in IBM i / Db2 for i Submitted

Provide a way to query Db2 for IBM i members

Currently, using OVRDBF to direct SQL statements to a specific database file member is functional, but it is not an ideal solution. It requires an external override that is disconnected from the SQL statement itself, making the code less self-cont...
30 days ago in IBM i / Db2 for i Future consideration

Enable multiple QDBSRV01 jobs to process requests concurrently on IBM i

We experienced highly utilized QDBSRV0 job that was processing internal journal entries (J-XP) only done via QDBSRV01. IBM i system provided QDBSRV01 operates as a single-threaded job that receives incoming requests and distributes most of the pro...
about 1 month ago in IBM i / Db2 for i Not under consideration

SPOOLED_FILE_INFO add parameter for spool file

I often spend time looking for certain spool files belonging to a user. At present I have to do: SELECT * FROM TABLE(QSYS2.SPOOLED_FILE_INFO( USER_NAME => 'HUTCHINSON')) WHERE SPOOLED_FILE_NAME = 'QPJOBLOG' ORDER BY CREATION_TIMESTAMP DESC ; ...
about 1 month ago in IBM i / Db2 for i Not under consideration

include production ready IFS primitives (i.e. delete, rename) working with ccsid 1200 (or other unicodes).

Please introduce production ready QSYS2 primitives (functions, table functions...) to interact with IFS using an SQL interface, like a delete operation (unlink) or rename, in order to orderly and cleanly compose with the other functionality of the...
about 1 month ago in IBM i / Db2 for i Future 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.