Relationships and Domains › Domains and Data Modeling › Domains in the Physical Model › Add a Domain in the Physical Edit Mode

Add a Domain in the Physical Edit Mode

You can work with the features in the Domain Editor to add a domain to the physical model.

Follow these steps:

1. Click Model, Domains.

   The Domain Editor opens.

2. Click the New button on the toolbar.

   A new domain with a default name is added and is placed in alphabetical order.

3. Work with the following options in the Navigation Grid:

   Physical Name

   Displays the name of the domain in the physical model.

   Domain Parent

   Displays the current parent domain. You can change the domain using the drop-down list.

   Physical Data Type

   Specifies the physical data type for the domain. You can change the data type using the drop-down list. The drop-down list contains the data types related to the current domain.

   Anchored to Type

   Specifies whether the domain is anchored to a column or a variable. This column is enabled only for a DB2 LUW user-defined data type.

   Schema

   Specifies the schema that is associated with the domain.

   Distinct Type

   Specifies whether the domain is of distinct type.

   Physical Only

   Specifies whether the domain appears only in the physical model. Select this check box if you want the selected domain to appear in the physical model only. Clear this check box if you want the selected domain in the logical model.

4. Work with the other tabs in the editor to define more domain properties.
5. Click Close.

   The domain is added to the physical model and the Domain Editor closes.

Back to Top

More information:

Summary of User Data Type Schema Generation Options

Specify a Validation Rule and Default Value for a Domain in the Physical Model

Specify a Column Definition Using a Physical Domain

Specify a Domain Comment in the Physical Model

Specify a Data Source For a Domain