Delta DDL generation from the compare editor

After you merge changes to data objects in the compare editor, you can generate a delta DDL script that contains a series of statements that you can run to change an object from its original state to the state after the merge.
This feature is available only when you compare the following types of data objects:

Generating and running delta DDL is the only way to save changes to a server object that you make changes to by using the compare editor. If you make changes to a model object in a project in the compare editor, you can either save the object or generate a delta DDL script.

The generated DDL scripts are optimized so that dropping and recreating tables is minimized when you are targeting DB2® for Linux®, UNIX®, and Windows®, or DB2 for z/OS®.

The Generate Left DDL Generate Left DDL toolbar button icon and Generate Right DDL Generate Right DDL toolbar button icon toolbar buttons are available only after you make changes to a data object by using the compare editor. When you click the toolbar buttons, a wizard opens so that you can specify a name for the DDL script and a project to store the script. In the wizard, you can also select to run the DDL script. If you select this option, you must provide connection information on the next pages of the wizard. If you do not select this option, you can review and edit the script in the SQL editor and then run it later outside of the workbench.

After you complete the wizard, the DDL script is saved and displayed in the SQL Scripts folder under the project that you specified.

Related concepts
Comparing and merging data objects

Feedback