Chapter 3 Building Physical Diagrams

Defining additional check parameters for objects in a PDM

You define additional check parameters for data constraints where standard check parameters are not sufficient.

Example

A table in a data model for a clothing shop may contain check parameters defined for a column SIZE, which depend on the check parameters defined on another column CLOTHING TYPE, as clothing size for a skirt in one country may be different from the same size in another country.

In this case an expression is required to create a constraint which uses check parameters defined for both columns.

To define additional check parameters:

1. Open the property sheet of a domain or column and click the Additional Checks tab.
   
2. Type a SQL expression, which may include any of the following variables:
   
   
   • %MINMAX% - Minimum and maximum values defined in Values groupbox on Standard Checks tab
   • %LISTVAL% - Customized values defined in List Values groupbox on Standard Checks tab
   • %RULES% - Validation rule expression defined on Expression tab of the Rules property sheet
3. Click OK.

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