Chapter 6 Using Data Integrity Features

Table of Contents

Setting the Error Checking Level

Using Table Check Constraints

Defining and Dropping Table Constraints

Adding a Column to the Recreation Database
Adding a Constraint to the Recreation Database
Dropping a Constraint from the Recreation Database

Defining and Dropping View Constraints

Deferring Constraint Error Checking

Locating Constraint Errors

Template for Single Column Unique Constraint Errors
Template for Multiple Column Unique Constraint Errors
Template for Single Column Referential Constraint Errors
Template for Multiple Column Referential Constraint Errors
Coding with Deferred Constraint Error Checking

There are several features involving data integrity which are not discussed in the language specific ALLBASE/SQL application programming guides. This chapter deals with them from a programming perspective under the following headings:

Setting the Error Checking Level.
Using Table Check Constraints.
Defining and Dropping Table Constraints.
Defining and Dropping View Constraints.
Deferring Constraint Error Checking.
Locating Constraint Errors

Most examples are based on the recreation database, RecDB, that is provided as part of the sample database environment, PartsDBE.

Refer to the ALLBASE/SQL Reference Manual and the ALLBASE/SQL application programming guides for complete syntax and further discussion of constraint features.

Chapter 6 Using Data Integrity Features

Technical documentation

» Table of Contents

» Index