Advanced Database Concepts Defining Record Restrictions

• Syntax:

restrict(index id): routine([parm]) \

from(fieldlist) mask(bit mask) \ [norm(year normalization value)]\ [terms(termlist][init(init value)]

• Example:

restrict(21): year_strct(3) from (101/5) \ mask(0000000000111111) norm (1950)

restrict(22): strmatch_strct(1) from (102/1) \mask (1100000000000000) terms(“english”,“french”,“german”)

Previous slide

Next slide

Back to first slide

View graphic version