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

FILTER BY CATEGORY

Db2 for i

Showing 319 of 3945

DLTF enhancement to remove dependant LF

DLTF can be instructed for special constraint handling by use of parameter RMVCST()Please add possibility to remove dependant LF with a parameter like DLTDEPLF(*YES) Use Case: Currently, dependencies need to be found with DSPDBR. Automatic file pr...
about 3 years ago in IBM i / Db2 for i 6 Future consideration

CTE support in MERGE statement

Currently MERGE statements in DB2 for i do not support the use of CTEs inside the using clause. Use Case: Lately, I've come across the need for this funtionality several times when I had to update large amounts of records in our ERP with data gath...
almost 2 years ago in IBM i / Db2 for i 5 Future consideration

DB2 Alter Table Rename column

DB2 for LUW and z/OS provide the capability to rename a column. DB2 for i should have the same functionality. Renaming a column's system name should be included, too. Use Case: In our IT department, Data Studio is used to create or modify tables a...
almost 7 years ago in IBM i / Db2 for i 8 Future consideration

Provide an SQL service to retrieve same data as DSPFFD command to OUTFILE for non-db2 objects such as DSPF, DDM, etc

When writing applications that utilize DSPFFD information, today you must code the command. An SQL service could provide flexibility and granularity to access this data for specific objects, similar to SYSCOLUMNS or OBJECT_STATISTICS.
7 months ago in IBM i / Db2 for i 1 Future consideration

Eliminate the Propagation of READS SQL DATA in Caller Functions in SQL

When creating User Defined Table functions in SQL, the CONTAINS SQL, READS SQL DATA and MODIFIES SQL DATA statements are currently propagated up the food chain. This means if a simple function calls another function, that called function's attribu...
over 1 year ago in IBM i / Db2 for i 2 Not under consideration

DBMS_OUTPUT (or alternative)

When writing compound statements and executing them interactively I would like to display certain output.
about 1 month ago in IBM i / Db2 for i 2 Functionality already exists

Add a YEAR_ISO function

Add a YEAR_ISO function to get the ISO year of a given date/timestamp. The VARCHAR_FORMAT function can be used with the 'IYYY' format to optain the ISO year but it would be nice if there were a shorthand just like with WEEK_ISO and DAYOFWEEK_ISO. ...
almost 2 years ago in IBM i / Db2 for i 2 Future consideration

Improve tracking of what job is the client job for QSQSRVR jobs with ability to review over time

Today, a CPF9898 message is logged to the QSQSRVR job log with the server mode connecting job information. This is useful while the client is actively using the job, but it is insufficient to assess the overall workload on QSQSRVR jobs by the vari...
8 months ago in IBM i / Db2 for i 1 Future consideration

Obscure the RUNSQL and RUNSQLSTM Workfile names in QTEMP

When using RUNSQLSTM in CL, a source file is created in QTEMP with the name QSQLSRC.Users with QTEMP on their library lists now have a "magically appeared" file on their library list that may cause corruption of tasks that previously ran normally....
over 1 year ago in IBM i / Db2 for i 3 Not under consideration

RPGLE embedded SQL nested datastructure (array)

It would be useful to allow nested ds and nested ds arrays for hostvariables in embedded SQL (RPGLE). Because now i have to move the nested subfield into a secondary standalone field.This is a horrible workaround :-) . Use Case: CASE WHEN :Example...
over 4 years ago in IBM i / Db2 for i 6 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.