This chapter explains the use of statement level integrity
versus row level integrity.
Also, methods of implementing schema level unique and referential
integrity contraints in your database are highlighted.
Integrity constraints allow you to have ALLBASE/SQL verify
data integrity at the schema
level. Thus you can avoid coding complex verification routines
in application programs and avoid the increased execution time of
additional queries.
Your coding tasks are simplified, and performance is improved.
The following sections are presented in the chapter:
Comparing Statement Level and Row Level Integrity.
Using Unique and Referential Integrity Constraints.
Designing an Application Using Statement Level Integrity Checks.
