checking

Specify when constraint checking should be performed.

USYS$INF_PARAMS checking {deferred}

Use

Only effective with transaction logging.

Description

This option allows you to determine when constraint checking should be performed—at the end of the statement (‘immediate’) or at the end of the transaction (deferred).

If this option is not present, checking mode is ‘immediate’, meaning that the constraint checking will be performed at the end of the statement.