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 381

Add SQL Object Type to QDBRTVFD and QUSROBJD APIs

Today the SQL object type is available only via the QUSRMBRD (Retrieve Member Description) API. However when a file has NO MEMBERS, the QUSRMBRD API cannot be used to retrieve the needed SQL Object Type. Ironically, the QDBRTVFD (Retrieve File Des...
8 months ago in IBM i / Db2 for i 3 Functionality already exists

Adjust the functionality of AUDIT_JOURNAL_* table functions

I think the current behavior is quite confusing. For example, if I'm trying to retrieve the QAUDJRN "PW" entries from a specific receiver, I might try this: SELECT * FROM TABLE ( SYSTOOLS.AUDIT_JOURNAL_PW(STARTING_RECEIVER_LIBRARY => 'QSYS', ...
9 months ago in IBM i / Db2 for i 4 Not under consideration

Provide an ALIAS-like feature for Library Names (SCHEMAs) in SQL statements.

Provide a way to assign an alternate (i.e. "short") name to schemas/libraries when used within an SQL statement. This is different from the Long SQL Name and the Short System Name. What I want to do is something like: select * from table(ST.myfunc...
about 3 years ago in IBM i / Db2 for i 2 Not under consideration

Custom HTTP Header Fields Should Replace Supplied Defaults in the QSYS2 HTTP Functions

When using the QSYS2 HTTP functions, custom HTTP request fields can be supplied. These supplied fields should replace any defaults provided by the HTTP functions. For example, the HTTP request field "Host" is automatically supplied by the HTTP fun...
12 months ago in IBM i / Db2 for i 6 Is a defect

Enhance RUNSQLSTM C compiler Please!

The C compiler used for compiling SQL Functions and Procedures is badly in need of an update."Create SQL ILE C Object" as it is called limits too much of the C compiler features. Use Case: When RUNSQLSTM calls the "Create SQL ILE C Object" compile...
about 3 years ago in IBM i / Db2 for i 2 Not under consideration

Add CREATOR/DEFINER Attribute to File Members

We need 1 to 3 new User Profile attributes added to Source File Member descriptions.Creator (Added by user profile)Change (Data Last Changed by user profile)Custom User Profile (application controlled) The creator user profile should be assigned t...
almost 3 years ago in IBM i / Db2 for i 2 Future consideration

ifs_object_statistics with /QNTC

We would have liked ifs_objects_statistics to report entries in the /QNTC file system. Our fall back is some IFS API's that will handle this. Use Case: We have a requirement to read the contents on a Windows server and then to pull .xml files from...
over 4 years ago in IBM i / Db2 for i 1 Future consideration

Add IMPLICITLY HIDDEN to SQL VIEWs

The TABLE feature to implicitly hide certain columns/fields when "SELECT *" is used, is great. However ,we need that feature extended to SQL VIEWS. Use Case: If I create a VIEW that contains a subset of columns, including implicitly hidden columns...
almost 3 years ago in IBM i / Db2 for i 2 Future consideration

Allow variables defined with like(<file-field>) to be used as embedded SQL host variables

If a variable in RPGLE is defined with like, and the source field comes from an external file (PF, DSPF, etc), the SQL preprocessor does not like it. Example: dcl-f CUSTMAST keyed; dcl-s qCust like(CUSTNUM); // CUSTNUM defined in CUSTMAST If I att...
9 months ago in IBM i / Db2 for i 3 Future consideration

Suppress Handled SQL Messages from Joblog

SQL places a lot of messages in the joblog. When diagnosing a problem from a joblog it is often difficult to wade through which messages can be ignored and which messages represent a problem that needs further investigation. It is also often impos...
over 6 years ago in IBM i / Db2 for i 3 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.