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.
