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