WAIT_FOR_COMMIT option

Function

Determines when foreign key integrity is checked as data is manipulated.

Allowed values

ON, OFF

Default

OFF

Scope

Can be set for an individual connection or the PUBLIC group. Takes effect immediately.

Description

If this option is set to ON, the database does not check foreign key integrity until the next COMMIT statement. Otherwise, all foreign keys not created with the CHECK ON COMMIT option are checked as they are inserted, updated, or deleted.