Use this page to specify the data model to import and where you want the generated model to be saved in the Data Project Explorer. The text box provides additional information about the model format that you select.
Use this page to specify the options for importing the data model. The text box provides additional information about the options that you can set for the model format that you selected.
For CA ERwin or CA Gen physical data models targeting DB2 for z/OS or DB2 for Linux, UNIX, and Windows only: Select a DDL script that contains additional database-specific properties; for example, storage properties. The DDL script must follow correct DB2 for z/OS or DB2 for Linux, UNIX, and Windows syntax.
When you select a DDL script or set of scripts from the file system, the wizard merges the information in the source model with the information in the DDL scripts when it creates the physical data model in the workbench. To select a single DDL script, choose the Select a DDL file option. To select multiple DDL scripts, choose Select a DDL file directory, and all of the DDL scripts that are contained in that directory are used during the import.
Select Overwrite model properties from DDL to use the properties in the DDL scripts instead of the properties in the imported data model, if there are conflicts.
Select Generate DDL on finish to optionally generate a DDL script that contains all of the merged imported properties. The DDL script is saved in the target data design project for modification as needed.
If there are errors in either the model or the DDL scripts, they are shown on the Summary page and the Finish button is disabled.
Correct any errors and verify the options that you specified, and then click Finish to import the data model.