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,
Post an idea
Upvote ideas that matter most to you
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 firstname.lastname@example.org for resolution.
For more information about IBM's Ideas program visit ibm.com/ideas.
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.
- 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.
Do not place IBM confidential, company confidential, or personal information into any field.