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 366 of 4306

Add the "Command to Run" field to the JOB-INFO table query

Please add the "Command to Run" parameter to the query. It has nearly all the commands parameters except this one. Use Case: We use a complex process at month end to prepare jobs to run at month end. I need to be able to view the jobs submitted to...
over 2 years ago in IBM i / Db2 for i 4 Not under consideration

cpyfrmimpf should handle commas.

The cpyfrmimpf command handles values similar to 123.45 and -678.90 in a numeric field, but sends message CPF2845, reason code 7 for values like 1,123.45 or -1,678.90. The command should handle commas as well as decimal points and minus signs. Use...
over 3 years ago in IBM i / Db2 for i 4 Not under consideration

Prevent ALTER TABLE when field size expanded and there is a field procedure

When a field procedure is assigned to a field, in our case for purposes of encrypting the field data, and an ALTER TABLE is allowed to execute against the field to expand the field size, then data corruption occurs. Use Case: Example Create table ...
over 3 years ago in IBM i / Db2 for i 4 Not under consideration

CPYTOSTMF

The CPYTOSTMF does not have the functionality to create a "Native Excel" XLS or XLSX file when the FROMFILE is an Physical file . Currently the CPYTOSTMF creates a delimited file separating fields using a comma, tilde, semicolon, etc. Suggest the ...
over 3 years ago in IBM i / Db2 for i 6 Not under consideration

Add options to TRUNCATE to support clearing a single partition (member)

The SQL TRUNCATE statement currently only supports removing data from the entire table, even when run against an ALIAS created against a single partition. Use Case: Fast truncation of a single partition (member), just like CLRPFM with a specific m...
almost 4 years ago in IBM i / Db2 for i 2 Future consideration

have STRSQL inform user about *POINTER output in table functions

playing around with new functions like qsys2.ifs_object_statistics.First was confused when using STRSQL that PATH_NAME is reported as *POINTER; using the iACS GUI execute SQL function the result was ok.Have STRSQL either display correct values (ev...
about 4 years ago in IBM i / Db2 for i 2 Not under consideration

Hope IBM i can have DB2 Order By COLLATION KEY BIT scalar function

Customer need to Order By some DBCS Chinese field by Chinese stroke order. In open platform UDB DB2, can use COLLATION_KEY_BIT scalar function -- https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0050491.htm...
over 4 years ago in IBM i / Db2 for i 4 Future consideration

Allow variable name as part of three part naming

Allow variable name as part of three part naming. Use Case: FOR V1 AS C1 CURSOR FOR select x.* from table( values('RACK1HST'), ('GDWEB'), ('GDIHQ1'), ('GDISYS1'), ('MAIL1'), ('RACK2HST'), ('GDWEB2'), ('GDIHQ2'), ('GDISYS2'), ('MAILTWO'), ('RACK3HS...
over 5 years ago in IBM i / Db2 for i 1 Not under consideration

Add variable support on CONNECT statement within SPL

Add variable support for CONNECT statement in SPL. Use Case: CREATE or replace PROCEDURE BACKUP_STATUS LANGUAGE SQL MODIFIES SQL DATA P1: BEGIN DECLARE COMMAND CHAR(200); -- Ensure this is large enough. DECLARE V_SYSTEM_NAME CHAR(25); FOR V1 AS C1...
over 5 years ago in IBM i / Db2 for i 1 Not under consideration

Add Job Date Column as SPOOL FILE CREATION JOB DATE to OUTPUT_QUEUE_ENTRIES UDTF

The CREATE_TIMESTAMP column of the QSYS2.OUTPUT_QUEUE_ENTRIES UDTF is the System Date/Time that the SPOOL file was created. However, the need for the Job Date/Time on which the SPOOL File was created is needed. Need a new column JOB_RUN_DATE that ...
about 6 years ago in IBM i / Db2 for i 5 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.