New Features and Enhancements › Merge Alter Table Statements for DB2 LUW

Merge Alter Table Statements for DB2 LUW

CA ERwin Data Modeler Service Pack 8.2.6 includes an enhancement to the Forward Engineering Template of DB2 LUW. When you generate the alter script, the Merged Alter Table Statements option is displayed when you select Other Options. This option merges the ALTER TABLE statement for an entity and generates a single ALTER TABLE statement, if the table is not dropped and created. If a property change requires a table to be dropped and created, such ALTER TABLE statements are not merged.

Note: After three units of work that include ALTER TABLE operations have been performed, run a REORG TABLE command. For more information, see the IBM documentation.

For the issues fixed in this release, see the Issues Fixed in this Release topic.