Using a validation rule in check parameters in a CDM

Chapter 3 Building Conceptual Data Models

Using a validation rule in check parameters in a CDM

A validation rule is a rule that validates data based on a corresponding business rule. A validation rule can be generated as a check parameter when the following conditions apply:

Validation rule is attached to an entity, entity attribute, or domain
Validation rule is defined as a server expression

At generation, validation rule variables are instantiated with the following values:

Variable	Value
%COLUMN%	Code of the column to which the business rule applies
%DOMAIN%	Code of the domain to which the business rule applies
%TABLE%	Code of the table to which the business rule applies
%MINMAX%	Minimum and maximum values for the entity attribute or domain
%LISTVAL%	List values for the entity attribute or domain
%RULES%	Server validation rules for the entity attribute or domain

For more information on defining business rules, see the Using Business Rules in a CDM chapter.

To use a validation rule in check parameters:

Open the property sheet of a domain, entity, or entity attribute, and click the Rules tab.

Click the Add Objects button to open a selection box, and select a business rule in the list.

Click OK in each of the dialog boxes.

Validation rule expressions
You must click the Rules button to modify the expression attached to a validation rule. You can also modify validation rule expressions from the list of business rules, by clicking the Define button.