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

My ideas: Db2 for i

    Showing 164

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

    SQL Add ANCHOR DATA To (%TYPE) functionality

    The lack of support for the %TYPE or ANCHOR DATA TO for data declarations affects our ability to port databases that use this functionality. We are looking at porting a Postgres based application to IBM i and have a large number of functions that ...
    over 6 years ago in IBM i / Db2 for i 2 Future consideration

    DB2 Next Identity Value has incorrect value

    The majority of new tables we create contain a record identity column defined as GENERATED BY DEFAULT, starting at 1, increment by 1. This column is also the primary key for the tables. Most inserts into tables do not specify a value for the recor...
    about 9 years ago in IBM i / Db2 for i 2 Future consideration

    Add SQL functions to return elements from qualified job name

    When we use the IBM i Services or SQL PL we often have a qualified job name, e.g. in the global variable QSYS2.JOB_NAME. Many of the services have been expanded with the elements of the job name in addition to the qualified job name. i.e. job name...
    21 days ago in IBM i / Db2 for i 1 Future consideration

    Make SQL function URL_ENCODE support RFC3986

    RFC3986 dictates that any space in a URL must be converted to "%20". However, when we run "values URL_ENCODE(' Hello there!'), we get "Hello+there%21" with the plus sign instead of "%20". The same is output from URLENCODE in SYSTOOLS. It seems lik...
    21 days ago in IBM i / Db2 for i 2 Future consideration

    FETCH LAST n ROWS ONLY Support in SQL for IBM i

    FETCH LAST n ROWS ONLY Support in SQL for IBM i Summary Currently, DB2 for i allows developers to fetch the first n rows of a result set using the FETCH FIRST n ROWS ONLY clause. However, there is no direct equivalent syntax to fetch the last n ro...
    3 months ago in IBM i / Db2 for i 3 Future consideration

    Allow a "FOR SYSTEM NAME" for CREATE ALIAS

    DevOps providers want to be able to fallback and restore implementation objects of SQL objects. CREATE ALIAS creates a *FILE DDMF in the library but we are not able to control the implementation name. This requires a lot of processing to make sure...
    5 months ago in IBM i / Db2 for i 2 Future consideration

    new IBM i SQL service to return additional TCP/IP information

    with the addition of some new services that do DNS lookup functions(thanks!) we need a service that shows the current DNS configuration for the server. CFGTCP <option 12> is the data i am referring to.
    over 1 year ago in IBM i / Db2 for i 3 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 2 years ago in IBM i / Db2 for i 2 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.
    almost 3 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.