Db2 Tools

 View Only

Back to discussions
Expand all | Collapse all

Did You Know? CenterStage Use Case: Generate DDL Statements for Related Database Objects

  • 1.  Did You Know? CenterStage Use Case: Generate DDL Statements for Related Database Objects

    Broadcom Employee
    Posted May 07, 2026 11:34 AM

    As a database administrator, you often need to generate DDL for a database object and its related objects (hierarchical DDL/HDDL) to understand the relationships between the objects and referential integrity constraints. 

    Using CenterStage, you can review the generated DDL and HDDL to:

    • Determine the impact of changes when migrating from a test or development system to production.

    • Generate SPUFI compatible HDDL output to save scripts and run them online or in batch.

    • Generate GRANT statements.

    You can also open the DDL in the SQL Editor and change and update as needed to prepare for a new release or address any issues.

    For more information, see Generate Hierarchical DDL in the CenterStage documentation.



    -------------------------------------------