Sybase 7.5 manual Defining check parameters, Setting standard check parameters for objects, 130

Models: 7.5

1 288
Download 288 pages 28.98 Kb
Page 140
Image 140

Defining check parameters

Defining check parameters

Check parameters are set of conditions which data must satisfy to remain valid. They are used principally in for use in a CDM or a PDM.

There are two types of check parameters:

Parameter type

Standard parameters

Additional check parameters

Validation rule

Description

Common data constraints which define a data range. For example minimum and maximum values for an attribute

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

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

Can be attached to

Attributes

Domains

Attributes

Domains

Classes

Attributes

Domains

Setting standard check parameters for objects

Standard parameters indicate common data constraints. The following table lists standard parameters:

Parameter

Minimum

Maximum

Default

Format

Unit

Uppercase

Lowercase

Cannot Modify

List of Values

Description

Lowest acceptable numeric value

Highest acceptable numeric value

Value assigned in absence of an expressly entered value

Data format (for example, 9999.99)

Standard measure

Forces all alphabetical characters to uppercase

Forces all alphabetical characters to lowercase

Protects from changes, results in a nonmodifiable attribute in the class

Authorized values

130

Page 140
Image 140
Sybase 7.5 manual Defining check parameters, Setting standard check parameters for objects, 130