If you make additional changes to your DDL after you have generated
your change commands, you have the option to merge these changes. DB2® Change Management Expert will detect additional
changes and prompt you to merge them by using the Merge Editor.
If you have already generated your change commands, and make an additional
change, you must use the Merge Editor to merge those changes into one change
command script. For example, if you add a GRANT statement to your existing
DDL script by using the Change Command Editor and then generate
change commands, DB2 Change Management Expert will
prompt you to merge your changes.
To merge your change commands, complete the following steps:
- After you have made one change to the target model, on the Change
Commands tab of the Deployment Script Editor, click Generate
Change Commands. Your new change commands script will
appear under the SQL Scripts folder in the Data Project Explorer view.
- If you make an additional change to your target model, you will
not lose that change. For example, if you added another statement to the change
command script or added a column to your target model. When you generate your
change commands again, you will be prompted to merge your changes.
- On the Change Commands tab of the Deployment
Script Editor, click Generate Change Commands. DB2 Change Management Expert will
prompt you with a message asking you if you want to merge your changes. Click Yes to
display the Merge Editor.
- In the Merge Editor, select the additional change from the Calculated
Change Commands side of the editor and click the left arrow button to move
your change to the Existing Change Commands side of the editor. Click OK to
merge your changes.
You have now successfully merged your changes into one change command
script.