Details: Specifying referential constraint rules—journaling requirements

 

If you perform insert, update, or delete operations on a file that is associated with a referential constraint, and the delete rule, update rule, or both are other than *RESTRICT, use journaling.

You must journal both the parent and the dependent files to the same journal. In addition, you are responsible for starting the journaling for the parent and dependent files.

You can start the journaling for the parent and dependent files with the Start Journal Physical File (STRJRNPF) command.

If you are inserting, updating, or deleting records to a file associated with a referential constraint that has a delete rule, update rule, or both rules, other than *RESTRICT, commitment control is required. If you have not started commitment control, the system starts and ends the commit cycle automatically for you.

 

Parent topic:

Specifying referential constraint rules

 

Related reference

Start Journal Physical File (STRJRNPF) command