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.