Set Referential Integrity Enforcement

Designing the Data Structure › Data Model Transformation › How to Set Technical Design Properties › Set Referential Integrity Enforcement

Set Referential Integrity Enforcement

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

Option	When to Use
CA Gen-enforced RI	If you want CA Gen to enforce RI. CA Gen generates pieces of code to handle all of the referential integrity.
DBMS-enforced RI	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.

Option

When to Use

CA Gen-enforced RI

If you want CA Gen to enforce RI. CA Gen generates pieces of code to handle all of the referential integrity.

DBMS-enforced RI

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.