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 153

Add SQL Option for Timestamp Format

The Db2 for i format of Timestamp is yyyy-mm-dd-hh.mm.ss.nnnnnnThe ODBC and JDBC format of timestamp is yyyy-mm-dd hh:mm:ss.nnnnnnIt should be possible to change the Db2 Timestamp format similar to how it can be done for date and time so that Db2 ...
over 6 years ago in IBM i / Db2 for i 3 Future consideration

Support *LIBL on RUNQRY QRY()

Hi, When creating a query definition, the library is resolved at creation time and not at runtime. This method is unlike any other function on IBM i and doesn't allow the query to be used with another library list as it is ignored. This way you ca...
over 2 years ago in IBM i / Db2 for i 3 Future consideration

External Tables

It would be very useful to have tables whose content is given by text files, such as Oracle's External Tables. in Oracle this functionality is obtained like this: CREATE TABLE my_ext_table ( id NUMBER, author VARCHAR2(30), created DATE, text CLOB ...
about 1 year ago in IBM i / Db2 for i 2 Future consideration

Multi-row insert in dynamic SQL RPG

Please enhance dynamic SQL support in RPG to include multi-row insert. Use Case: Dcl-DS myQualDS ExtName('THETBL') Dim(200) Qualified Inz; End-DS; myQualDS (1).dta = '1'; myQualDS (2).dta = '2'; Ctr = 2; SQLStatement = 'Insert into THETBL ? rows v...
over 6 years ago in IBM i / Db2 for i 2 Future consideration

Add optional argument for XMLPARSE

To use XMLPARSE, the external encoding of the data need to be consistent with XML prolog. But, often, the encoding of the variable (in hosted langage or CLOB) isn't the same as original value. For example : when we receive an XML file by FTP or ot...
almost 3 years ago in IBM i / Db2 for i 1 Future consideration

Create SQL Functions ("IBM Services") that retrieve the Problems database information (QASX* files and WRKPRB command)

Using WRKPRB we can see some of the information related to hardware and software problems. That info is stored in the QAXS* database files in QUSRSYS. I would like a set of SQL Table functions or VIEWS that can be used to access that information v...
over 2 years ago in IBM i / Db2 for i 3 Future consideration

get_xml_file() need to be encoding agnostic

The get_xml_file() is a fantastic tool to load XML files from the IFS. However it will fail if data is stored in utf-16LE format.
over 2 years ago in IBM i / Db2 for i 1 Future consideration

Add the Module feature to PL/SQL

To improve modularity and maintainability of PL/SQL code, could you please add to DB2 for i, the support of modules, which already exists on other DB2 platforms : https://www.ibm.com/docs/en/db2/9.7?topic=modules-referencing-objects-defined-in Thi...
almost 2 years ago in IBM i / Db2 for i 1 Future consideration

Please finish/complete the integration of long SQL names into Db2 for i

When Long SQL Names are used, you can only rename those object using the SQL RENAME statement. However, RENAME supports only TABLEs, VIEWs, and INDEXes. Which means *FILE objects only. Sequences, Variables, Functions, Procedures, and the myriad ot...
almost 2 years ago in IBM i / Db2 for i 3 Future consideration

Add Db2i for i Service to maintain validation list

Please add a DB2 for i service that looks at/maintains the users under validations list under the HTTP admin server. If you need to rename a user today you can't, you have to recreate the user. Having a service like this will help helpdesk and/or ...
over 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.