Referential Constraints IBM i

Referential Constraints will enforce data integrity

Benifits of using Referential Constraints IBM i

Accuracy – prevent orphaned records by letting the RDBMS validate the parent/child relationships between tables 

Performance  – RDBMS runs in the operating system storage pool and provides excellent performance

Functionality- The functionality provided by the constraints is all functionality that need not be performed in the programs, resulting in less coding and testing