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 146

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.
almost 2 years ago in IBM i / Db2 for i 1 Future consideration

please include all the data from DSPHDWRSC in the view QSYS2.HARDWARE_RESOURCE_INFO

this would help to get additional important ant data from the system
about 1 year ago in IBM i / Db2 for i 2 Future consideration

Requesting AUDIT_JOURNAL_SF table function

I have hundreds of printer devices and output queue entries. Many are obsolete. I would like to query the audit journal for SF entries for the latest entry involving any device and/or output queue. Something like select printer, max(entry_timestam...
11 months ago in IBM i / Db2 for i 1 Future consideration

INSERT CAST error should provide column name

If a SQL INSERT into a table fails with a SQLSTATE of 22018 (Character in CAST argument not valid), it doesn't provide the column name upon which the CAST failed. Db2 has to know which column it was operating on, it just doesn't provide that to th...
over 6 years ago in IBM i / Db2 for i 5 Future consideration

UDTF returning dynamic resultset

Today stored procedures can return dynamic result sets. It will be appreciated if UDTF could have the same feature. Today you can only return a TABLE, you need however to define each column even though a cursor will contain the required informatio...
over 5 years ago in IBM i / Db2 for i 3 Future consideration

Enhancements to RPGLE SQLTYPE

I would like to be able to define an SQLTYPE field as a TEMPLATE. I would also like to be able to use a named constant for the SQLTYPE size parameter. An example: dcl-c $len_rcCLOB 2000000; dcl-s t_rcCLOB sqltype(CLOB: $len_rcCLOB) template; dcl-s...
over 1 year ago in IBM i / Db2 for i 2 Future consideration

Allow *LIBL or omitted library on INCLUDE statement in SQL Stored procedures and Functions

The INCLUDE statement used to include C code in an SQL LANGUAGE Stored Procedure or User Defined (Table) Function requires an explicit library name. Common software development practices will have different versions or levels of code in different ...
over 3 years ago in IBM i / Db2 for i 2 Future consideration

JavaScript (Node.js) as native stored procedure / UDTF language

Today we can use PL/SQL, java and any other ILE language to make stored procedures and UDTF in Db2. However new languages are being used for modern application ie javaScript within Node.js and Python to name a few - and and other languages from th...
over 5 years ago in IBM i / Db2 for i 5 Future consideration

SQL Services should support audit journal & authority collection

Currently usage of IBM i Services (SQL) (e..g QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC ) can fail with an authority failure without logging to the OS audit journal or showing up in authority collection. Per IBM support, this is working as designed. I'm co...
over 3 years ago in IBM i / Db2 for i 4 Future consideration

Please create SQL service to retrieve PCML from compiled modules

Breaking out this part from https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3437 Please create a SQL service to retrieve PCM from compiled programs like the QBNRPII but easier to use. My personal use case for this is to automatically create P...
about 2 years ago in IBM i / Db2 for i 1 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.