Chapter 4 Building Physical Diagrams


Check Parameters (CDM/LDM/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/Entity attributes

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/Entity attributes

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

Columns/Entity attributes

Domains

 


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