Ch 6. Using Data Integrity Features [ ALLBASE/SQL Advanced Application Programming Guide ] MPE/iX 5.0 Documentation
ALLBASE/SQL Advanced Application Programming Guide
Chapter 6 Using Data Integrity Features
[REV BEG]
There are several features involving data integrity which are not
discussed in the language specific ALLBASE/SQL application programming
guides.[REV END] 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.
MPE/iX 5.0 Documentation