Chapter 3 Building Physical Diagrams


Defining check parameters in a PDM

Check parameters are set of conditions which data must satisfy to remain valid.

There are three types of check parameters:


Parameter type

Description
Can be attached to
Standard check parameters Common data constraints which define a data range. For example minimum and maximum values for a column Columns

Domains
Additional check parameters SQL expression defining a data constraint using the %MINMAX%, %LISTVAL%, and %RULES% variables that are instantiated with standard parameter values Columns

Domains
Validation rule Business rule that is defined as a server expression, and is attached to one of the following listed objects Tables

Columns

Domains

 


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