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 202

    List procedures that a program uses in PROGRAM_EXPORT_IMPORT_INFO

    Despite the name, the PROGRAM_EXPORT_IMPORT_INFO does not actually list the procedures imported by a program. This is important because, when the signature of a procedure changes, all programs that import (use) the procedure must be changed. Impor...
    10 months ago in IBM i / Db2 for i 1 Delivered

    Using SYSTOOLS.GENERATE_SPREADSHEET to export data to excel, using an existing excel template.

    Be able to use an excel template, SPREADSHEET_TEMPLATE, to put the generated data in, setting sheet SPREADSHEET_SHEET and cell SPREADSHEET_CELL where to start put the data.
    almost 2 years ago in IBM i / Db2 for i 3 Delivered

    Change SQL function TIMESTAMPDIFF result from INTEGER to BIGINT

    The SQL scalar function TIMESTAMPDIFF currently returns an INTEGER result. When requesting a result in microseconds, INTEGER only works for a difference of about 35 minutes before getting an SQLSTATE 22001 error. A BIGINT result would allow a much...
    over 4 years ago in IBM i / Db2 for i 5 Delivered

    SQL drop if exists

    Please provide an IF EXISTS option on the DROP statement. For tables we have a CREATE OR REPLACE CONSTRUCT, however this isn't available for indexes/views/procedures... While a compound statement works, it requires multiple lines of code which is ...
    almost 6 years ago in IBM i / Db2 for i 3 Delivered

    API or DB2 SQL Service to return the OVRDBF information for a JOB

    It would be nice to have either a DB2 SQL Service or API that would return the information from DSPOVR. Currently the only way I know to do this at least for the current job is to do a DSPOVR *PRINT or DSPJOB *PRINT and read through the spool file...
    over 1 year ago in IBM i / Db2 for i 6 Delivered

    Add ability to output JSON elements/keypairs and objects on separate rows.

    Using SQL to output data in JSON format, the output is presented all on one line. When debugging, this is very difficult to work with. The request is to be able to split the 1 line into 1 keypair per line. The guide says too use the escape sequenc...
    4 months ago in IBM i / Db2 for i 1 Delivered

    Trigger administration

    This set up rights on the ADDPFRTG command identical to those set up on the SQL CREATE TRIGGER statements
    almost 2 years ago in IBM i / Db2 for i 3 Delivered

    CPF warning when system has reached 90% of 2.6 Million spool files

    CPI1468 - System job tables nearing capacity is generated before the system becomes unusable. Very nice. CPF4235 is generated when the number of spool files exceeds 2.6 Million. It would be helpful to receive a similar message when the Spool file ...
    over 5 years ago in IBM i / Db2 for i 8 Delivered

    Generate_Spreadsheet function needs ability to Kill the Java Daemon

    We use Generate_Spreadsheet scalar function to create xlsx spreadsheets from data files in IBM i. According to the documentation i have read and conversations with IBM support this function is basically using the ACS base for its functionality. Wh...
    about 1 year ago in IBM i / Db2 for i 2 Delivered

    Boolean data type in Db2

    The boolean datatype seam to be standard in other major database, so it will be a good opportunity to also have bool as a native type in DB2. I know you can use CREATE TYPE BOOL to make you own implementation, however it will not allow direct logi...
    almost 7 years ago in IBM i / Db2 for i 4 Delivered

    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.