Check options

Use the Check options radio buttons to specify the constraint that conforms to the definition of the view. A row that does not conform to the definition of the view is a row that does not satisfy the search conditions of the view. If a check option is specified for an updatable view that does not allow inserts, then the constraint applies to updates only.

Select one radio button to specify the check option you want for the view:

None

The definition of the view is not used in the checking of any insert or update operations that use the view. Because the definition of the view is not used, rows might be inserted or updated through the view that do not conform to the definition of the view.

Cascaded

Specifies the constraint on a new view such that the new view inherits the search conditions as constraints from any updatable view on which the new view is dependent. Every updatable view that is dependent on the new view is also subject to these constraints. Thus, the search conditions of the new view and each view on which the new view is dependent are ANDed together to form a constraint that is applied for an insert or update of the new view or of any view dependent on the new view.

Local

Specifies the constraint on a view V such that the search condition of V is applied as a constraint for an insert or update of V or of any view that is dependent on V.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]