Support for temporal referential constraint

Db2 12 introduces referential constraints for application-period temporal tables.

In previous versions, temporal referential integrity could only be enforced using triggers or stored procedures. In Db2 12, a temporal referential constraint can be defined for an application-period temporal table that contains a BUSINESS_TIME period. You can specify the PERIOD BUSINESS_TIME clause in the definition of a referential constraint that enforces a temporal referential constraint for an application-period temporal table.

FL 509 At application compatibility level V12R1M509 or higher, temporal reference integrity is enhanced to remove a restriction against UPDATE or DELETE statements on the parent table.