Generating DDL › How to Create a Database › Select Components for Generation

Select Components for Generation

You must select each of the database components for which you want to generate DDL. The components you can select include:

• Database
• Tablespace
• Data Table
• Link Table
• Indexspace

Note: Selecting a database component does not automatically select all of its subordinate objects. For example, selecting a tablespace does not include the records, index spaces, and indexes that are subordinate to it. To automatically select the subordinate objects, set the Apply to All Subordinates option (A) to Y.

From the DDL Generation window, select Select New Objects from the Edit menu. This displays a list of all of the types of components within a database. As you select component object types and List them, you can Add or Expand specific component objects of the application database to the list of items you want to generate.

Choose a component object type and select the List command. From the list that displays, you can Expand to lower level objects and add them to the generation list or you can select the Apply to All Subordinates option to select all of the subordinate objects. After you have added all of the desired components, you can generate the flagged components. You can also generate all databases and their components by selecting Model from the Generate menu.

Each of the lists of expanded objects allows you to select the DDL generation options (Generate DDL, Drop, Install, and Apply to All Subordinates) before you add the component to the list. Selecting Apply to All Subordinates causes all subordinate objects to be generated with the options selected for that component. As an alternative, you can select these options on the generation list for each component on an individual basis.

Important! In this release, if you exceed the maximum cardinality (50 objects) for the list, the extraneous objects are not updated or generated. This may require generation of the objects in two or more sessions.