DDL Generator

DDL Generator generates SQL for any existing object straight from the Db2 catalog. It builds the data definition language (DDL) for a single object, or even a group of objects. Besides the DDL, the tool also allows to include and automatically determine dependent objects, VSAM cluster definition (for user defined spaces) and authorizations.

The powerful renaming capabilities allow to apply changes to the current names before creating the objects in the originating, or a different Db2 system.

Key Benefits

  • Offers build-in renaming (e.g. database, qualifier, buffer pool, stogroup …)
  • Supports wildcard processing for includes and excludes
  • Resolves view dependencies
  • Handles sequences
  • Supports all functionality of current Db2 Versions