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 420 of 4752

Enhance QCMDEXC Scalar function to process an entire result set

I have hit a max limit on the QCMDEXC scalar function. for example, I have 243 jobs in the job scheduler and I need to hold them all with the exception of a few. I have to run my HLDJOBSCDE command using the qcmdexc scalar function about 3 times b...
over 1 year ago in IBM i / Db2 for i 4 Not under consideration

Add a warning when parameter markers are truncated

IBM i silently truncates parameters to prepared statements to match the length of the target. -----From https://www.ibm.com/docs/en/i/7.4?topic=statements-open, section "Parameter marker replacement" : However, unlike the rules for assigning a val...
over 1 year ago in IBM i / Db2 for i 1 Functionality already exists

0N002 - A character cannot be mapped to a valid XML character.

Since we started using SQL more and more to build and parse XML we are running into SQL state error of 0N002 - A character cannot be mapped to a valid XML character. Our only known fix for this is to do a regular expression statement on each colum...
over 8 years ago in IBM i / Db2 for i 2 Not under consideration

Support ability to 'Lock In' a DB2 Plan

The DB2 optimizer continually reevaluates all conditions/variables to create the best plan at that moment. And almost always, the optimizer creates the best plan. There are times however, when the optimizer makes a poor choice. And when it does, t...
over 8 years ago in IBM i / Db2 for i 1 Not under consideration

"create type" with all characteristics like column table

Improve the SQL "create type" command by adding the column header, the field text and all the possible features that are in a field of a table. In this way it would be possible to create the tables by simply referring to the "type" without definin...
almost 7 years ago in IBM i / Db2 for i 3 Future consideration

SQL - parse char string using external definition

Many times, in existing customers ERPs, there are fields where structured information is stored in a single big CHAR string. Usually the intent is to have a generic data carrying field in the same table, where the type of information is stored in ...
over 1 year ago in IBM i / Db2 for i 1 Not under consideration

Allow a SQL stored procedure to use 3 part naming without having to create a custom *SQLPKG on each target.

I created a sql stored procedure which looks like the following: CREATE PROCEDURE rob.PROPAGATE_QLNKOMT() LANGUAGE SQL MODIFIES SQL DATA SET OPTION DATFMT = *ISO P1 : BEGINDECLARE OMIT_LIST CHARACTER VARYING ( 32000 ) ; SELECT FSXCMD INTO OMIT_LIS...
over 1 year ago in IBM i / Db2 for i 2 Functionality already exists

DB2 Next Identity Value has incorrect value

The majority of new tables we create contain a record identity column defined as GENERATED BY DEFAULT, starting at 1, increment by 1. This column is also the primary key for the tables. Most inserts into tables do not specify a value for the recor...
over 8 years ago in IBM i / Db2 for i 2 Future consideration

Inline code for SQL procedures/function

Today you can use inline code in SQL procedures/functions with the "include" statement , but need to write the code in a separate file like this: call qsys2.ifs_write( path_name => '/tmp/main.c' , file_ccsid => 1208, overwrite => 'REPLACE...
almost 2 years ago in IBM i / Db2 for i 1 Not under consideration

Problem with CPYFRMIMPF command and file with CCSID = 1208 UTF-8

When using command CPYFRMIMPF FROMCCSID(1208) UTF-8 and *FIXED format, each national characters coded on 2 bytes are causing shifting of data in output file. As explained by iGSC in PMR 61492,001,822 when using *FIXED format and multi-byte code po...
almost 9 years ago in IBM i / Db2 for i 3 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.