Skip to Main Content
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.

Status Not under consideration
Workspace IBM i
Created by Guest
Created on Jan 25, 2012

From RBD/RDPi under Data perspective using Generate DDL producing incomplete SQL statement for Logical File (LF) in iSeries

In RBD&RDPi from Data perspective Generating DDL definition from an existing Logical File (LF) is populating incomplete SQL statement and getting error on execution.

I am on IBM RBD (Version 8.0.1.2) and IBM RDPi (Version 8.0.3). Under Data perspective while generating a DDL for a view from an existing Logical File (LF) is populating incomplete SQL statements and therefore on execution giving error. But for the same logical file from iSeries Navigator is generating correct and complete SQL statement.

For futher details please refer to the attached document.


Use Case:

1. Open RBD/RDPi
2. Go to Data Perspective
3. From Data Source Explorer connect to an IBM iSeries database (DB2/400)
4. Select an existing Schema/Library
5. Expand Views and select an existing Logical File (LF)
6. Right click on the LF and click on Generate DDL
7. Follow the steps after clicking Next button
8. The screen on which it shows the Preview DDL, you can see the incomplete DDL statement
9. In this screen check the Run DDL on Server checkbox and then click the Next button
10. After selecting the database connection and clicking Finish button comes up with error.


Idea priority High
  • Guest
    Reply
    |
    Sep 14, 2015

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Servers and Systems Software
    Product family - Programming Languages
    Product - Developer for Power Systems

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

  • Guest
    Reply
    |
    Mar 29, 2012

    Please open a Problem Management Record (PMR) to ensure that we have the diagnostic information needed to resolve this issue.? For more information on opening a PMR, please see:

  • Guest
    Reply
    |
    Feb 23, 2012

    Will raise a PMR as suggested. Once done will update with the same.

  • Guest
    Reply
    |
    Feb 17, 2012

    Thank you for taking the time to explain your issue with our product.  From the information provided, we are unable to reproduce the problem.  This issue would be more easily resolved by opening a Problem Management Record (PMR) to ensure that we have the diagnostic information needed to resolve this issue.  For more information on opening a PMR, please see:
    SR tool URL: http://ibm.com/software/support/probsub.html

  • Guest
    Reply
    |
    Jan 25, 2012

    Attachment (Use case): Steps for replicating the error details.