Logical Modeling › Domains and Data Modeling › Domains in the Physical Model › Specify a Validation Rule and Default Value for a Domain

Specify a Validation Rule and Default Value for a Domain

In a physical model, you can use the options in the Constraint tab in the Domain Dictionary dialog to specify the validation rule and default value information associated with a domain.

To specify a validation rule and default value for a domain

1. Click Domain Dictionary on the Model menu.

   The Domain Dictionary dialog opens.

2. Click the Constraint tab.

   The Constraint tab opens.

3. Work with the following options:

   Validation Constraint

   Adds or modifies a validation constraint.

   Name

   Displays the name of the validation rule attached to the domain. Select a different validation rule to apply to the selected domain. The validation rules can be created, modified, or deleted using the Validation Rules editor.

   Valid

   Click the button to open the Validation Rules editor.

   Default

   Adds or modifies a default value.

   Name

   Displays the name of the default rule attached to the selected domain. Select a different default to apply to the selected domain. The default rules can be created, modified, or deleted using the Default Values dialog.

   Default

   Click the button to open the Default/Initial Values dialog.

   Note: In addition to these standard options, you are provided with additional datatype, column storage, and display property support for some target servers, including Access, DB2 iSeries, Progress, and Teradata databases. For Oracle, a grid appears under the Validation Constraint section where you can add validation rules using the Validation Rules editor, and you can open the Oracle Constraint State Dialog to set additional constraint properties.

4. Click OK.

   Validation rules and default values are specified, and the Domain Dictionary dialog closes.