Using a Validation Rule in Check Parameters in a Data Model

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 a table/entity, column/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 column or domain

%LISTVAL%

List values for the column or domain

%RULES%

Server validation rules for the column or domain

For more information on defining business rules, see Business Rules (CDM/LDM/PDM).

  1. Open the property sheet of a table, domain, or column, and click the Rules tab.
  2. Click the Add Objects button to open a selection box, and select a business rule in the list.
  3. Click OK in each of the dialog boxes.
    Note:

    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.

Parent topic: Check Parameters (CDM/LDM/PDM)

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com