Set Generation Configuration Parameters

Generating DDL › How to Create a Database › Set Generation Configuration Parameters

Set Generation Configuration Parameters

You must set Generation Options before generating a database. Review the options for subsequent generations if the target or purpose changes.

To set generation configuration (environment) parameters:

Select DDL, Environment, and Configuration.
Select environment parameters from the fields available.

You will receive an error message if the combination of environment parameters you select is not valid.

Setting values from this location provides default parameters used for DDL generation actions. You can override these defaults from within the DDL Generation window. At a minimum, you must define the operating system and the DBMS that you are using for this generation.

Several flags affect the generation of a database. You toggle flags on and off by selecting the icon above the column. The default value, No, is represented by a blank. The specific actions that occur as a result of selection appear in the following sections. The flags are summarized in the following table:

Set This Flag	If You Want To
DDL (D) to Y	Generate source for the DDL for the database and/or its subordinate objects with the options set for the database.
DROP (R) to Y	Ensure the database installs even if a database already exists with that same name.
INSTALL (I) to Y	Install the database objects and create the remote file for remote installation.
APPLY TO ALL SUBORDINATES (A) to Y	Generate source for the DDL for the database and all of its subordinate objects.