SET Transaction Mode statement

Use the SET Transaction Mode statement to specify whether constraints are checked at the statement level or at the transaction level during the current transaction.

Syntax


                      .-,----------.                    
                      V            |                    
>>-SET CONSTRAINTS--+---constraint-+-+--+-IMMEDIATE-+----------><
                    '-ALL------------'  '-DEFERRED--'

Element	Description	Restrictions	Syntax
`constraint`	Constraint whose transaction mode is to be changed	All constraints must exist in the same database, which must support logging	Identifier

Usage

To enable or disable constraints, or to change their filtering mode, see SET Database Object Mode statement.

This statement is valid only in a database with transaction logging, and its effect is limited to the transaction in which it is executed.

Use the IMMEDIATE keyword to set the transaction mode of constraints to statement-level checking. IMMEDIATE is the default transaction mode of constraints when they are created.

Use the DEFERRED keyword to set the transaction mode to transaction-level checking. You cannot change the transaction mode of a constraint to DEFERRED unless the constraint is currently enabled.