Cloud Platform

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:

Post your ideas

Start by posting ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive a notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

If you encounter any issues accessing the Ideas portals, please send email describing the issue to for resolution.

For more information about IBM's Ideas program visit

Status Future consideration
Created by Guest
Created on Jan 18, 2012

Fully implement default schema and allow other properties for AS/400 Toolbox for Java driver in Database connection

The IBM data tools from Rational Application Developer is included in Rational Aplication developer for Power Systems Software which is used to develop software on the IBM i platform (formely AS/400). It includes a driver to connect to the IBM i (AS/400 Toolbox for Java).
When creating a connection using that driver, there is an input box for "default schema", however, any value entered here is ignored and has no effect. A PMR was opened and IBM's response was that the default schema entry comes from the underlying Eclipse DTP and support for it comes from the Database vendor and that IBM has decided to not implement it so far and need a RFE to consider it.

Another issue with the driver as implemented is that there is no way to set additional properties that are supported by the Toolbox driver (about 70 properties). For instance, the date format, the naming convention or the database name (so independant ASP can be accessed).

Note: In the PMR discussion, there was a mention that Data Studio also doeas not implement the default schema parameter but does use the value on the connection as the default for a similar field in the script editor. I did not find this feature in the version I could download and thus cannot say if that solution is acceptable. It may be if it issues a set current_schema statement before ruunning the script. But I would need someting similar for the scrapbook.

Use Case
- In data source explore view, create a connection using AS/400 Toolbox for Java as the driver. - Set the default schema to COMMON and the property date format to iso. - In the scrapbook run the following SQL: select * from calendar; Results: The records from table CALENDAR is schema COMMON are shown and there is no errors for dates outside the rage 1940-2039.
RFE ID 16972
RFE Product Rational Application Developer
Idea Priority High
  • Guest
    Sep 24, 2015

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - WebSphere
    Product family - Application Platform
    Product - Application Developer

    For recording keeping, the previous attributes were:
    Brand - Rational
    Product family - Design & development
    Product - Application Developer

  • Guest
    Apr 27, 2012

    This RFE will be under consideration for a future release. Status has been updated to Uncommitted Candidate.

  • Guest
    Feb 17, 2012

    This RFE is consistent with our strategy and product roadmap and IBM is continuing to evaluate.