HP 3000 Manuals HP 3000 Manuals
Chapter 10 Programming with Constraints 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.