Chapter 4 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:

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 section Defining a business rule in a CDM in chapter Using Business Rules in a CDM.

Steps To use a validation rule in check parameters:

  1. Click the Rules tab in the property sheet of a domain, an entity or an entity attribute to display the corresponding page.
  2. Click the Add Rules tool.

    A list is displayed displaying the available business rules in the model.
  3. Select a business rule in the list.
  4. Click OK in each of the dialog boxes.

    Note   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.


 

Copyright (C) 2006. Sybase Inc. All rights reserved.