Enforcement of business rules
The discussion of “Keys” on page 49 raises the topic of referential integrity. This section describes how referential integrity ensures data integrity by enforcing rules with referential constraints, check constraints, and triggers. You can put the database to work by using constraints and triggers. You can rely on these mechanisms to ensure the integrity and validity of your data, rather than relying on individual applications to do that work.
Referential integrity and referential constraints
Referential integrity is the state in which all values of all foreign keys are valid.
DB2 ensures referential integrity between your tables when you define referential constraints. A referential constraint is the rule that ...
Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
