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 OVRSCOPE to OVERRIDE_INFO

Please add the Override Scope, parameter OVRSCOPE in most OVRxxx commands, as a column to the results returned by the Override Information View, OVERRIDE_INFO. I find it surprising that this was missed from the specifications as most of us who nee...
8 months ago in IBM i / Db2 for i Delivered

Add a new service that will convert *DTS columns to character date format.

When selecting and displaying data from a file with columns of type *DTS char( 8) the column cannot be viewed correctly via SQL 'SELECT' or handled directly for file search and review. Using the TIMESTAMP_FORMAT or the VARCHAR_FORMAT functions wil...
9 months ago in IBM i / Db2 for i Delivered

Add a special register in SQL triggers to get the schema of the underlying table, at any point, not just in error handlers

In SQL Db2 for i, we would need the SQL triggers to provide a simple way to know the schema of the underlying SQL table of each trigger. It is important to have this data, especially when using library lists, because sometimes we need to pass this...
10 months ago in IBM i / Db2 for i Delivered

Extend the QCMDEXC SQL procedure and function to log the CL command run

Many SQL programmers using the QSYS2.QCMDEXC procedure and function are logging the CL command specified as parameter to the procedure / function, often to the joblog by calling SYSTOOLS.LPRINTF, just before calling QCMDEXC. The idea is to have QC...
11 months ago in IBM i / Db2 for i Delivered

Add SQL functions to return elements from qualified job name

When we use the IBM i Services or SQL PL we often have a qualified job name, e.g. in the global variable QSYS2.JOB_NAME. Many of the services have been expanded with the elements of the job name in addition to the qualified job name. i.e. job name...
11 months ago in IBM i / Db2 for i Delivered

Make SQL function URL_ENCODE support RFC3986

RFC3986 dictates that any space in a URL must be converted to "%20". However, when we run "values URL_ENCODE(' Hello there!'), we get "Hello+there%21" with the plus sign instead of "%20". The same is output from URLENCODE in SYSTOOLS. It seems lik...
11 months ago in IBM i / Db2 for i Delivered

Further enhancements to the SQL scalar GENERATE_SPREADSHEET functionality to allow naming a sheet

Along with the required enhancements to ACS to enable this in the scalar function, provide the ability to name that sheet when creating it in the xls or xlsx workbook. We now have the ability to append a sheet and specify which sheet to add so the...
12 months ago in IBM i / Db2 for i Delivered

Add ability to output JSON elements/keypairs and objects on separate rows.

Using SQL to output data in JSON format, the output is presented all on one line. When debugging, this is very difficult to work with. The request is to be able to split the 1 line into 1 keypair per line. The guide says too use the escape sequenc...
about 1 year ago in IBM i / Db2 for i Delivered

Add parameter for SEND_MESSAGE service that specifies Message Queue

THE SEND_MESSAGE and LPRINT functions are nice, but many of us have message queue monitoring utilities and would prefer to pick where to send the messages to other than QSYSOPR. Notably, MS Copilot already claims the parm is there!
about 1 year ago in IBM i / Db2 for i Delivered

Allow CREATE OR REPLACE TABLE to set the correct source info in the resulting table

When we create a table using CREATE TABLE to create a new table, the object description of the resulting table contains the source information for the source member used by RUNSQLSTM to create the table. When we use CREATE OR REPLACE TABLE to repl...
over 1 year ago in IBM i / Db2 for i Delivered

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.