Designing the Data Structure › Transforming the Data Model › Setting Technical Design Properties › Setting Referential Integrity Enforcement

Setting Referential Integrity Enforcement

The technical design property options for referential integrity enforcement are listed in the following list.

• CA Gen-enforced RI—Use this option if you want CA Gen to enforce RI. CA Gen generates pieces of code to handle all of the referential integrity.
• DBMS-enforced RI—Use this option if you want the DBMS to handle as much RI as possible. This keeps the amount of code generated as small as possible and helps system performance.

CA Gen allows the DBMS to handle all of the referential integrity it can and only generate pieces of code for the referential integrity not handled by the DBMS.