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 and Generate Right
DDL
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.