Building a Database › How to Build a Database › Set Generation Parameters

Set Generation Parameters

Set Generation parameters before generating a database. Review the options for subsequent generations if your target or purpose changes.

Follow these steps:

1. Select Construction.
2. Select Generation.
3. Select Options.
4. Select Generation Defaults.

CA Gen provides the following dialogs to configure your application for generation:

• Environment Parameters (choose the Environment menu option)
• Generation Defaults (choose the Generation menu option)
• Client and Server Environments Parameters (choose the Packaging menu option and for more information about procedures, see Distributed Processing - Overview Guide).

Note: The Environment Parameters window applies only to a business system, not to the model. You must specify the configuration for your database DDL, Referential Integrity (RI) triggers, and the type of installation (local or remote) for the model on the Generation Defaults window.

At a minimum, you must define the operating system and the DBMS that you are using for this generation, and whether this particular generation is for the local workstation or for a remote (target) environment.

Several other options are presented for your selection. For more information about these options, see the Toolset Help.

Several options affect the generation of a database. The specific actions that occur because of selection are explained in the following table.

The additional options do not apply to database generation.

The database generation check boxes and their functions are as follows:

Include Drop Statements in DDL (Gen All)

Ensures that your database installs even if a database already exists with that same name.

Note: This check box applies only to the Generate, All action and the Generate, All and Install action

Qualify Tables and Indexes with Owner ID

Enables each person to have a unique databse when more than one person is testing with the same workstation.

Create Storage Group in DDL

View the SQL statements for storage groups in DB2.

Run Consistency Check for each item generated

Ensures consistency of the component you are generating.

Create RI Alter Primary/Foreign Keys & Triggers

Creates an alternate referential integrity primary and foreign key triggers for comparison with an existing database.