SET CONSTRAINTS

Use the SET CONSTRAINTS statements to specify how some or all of the constraints on a table are processed. Constraint-mode options include these:

Whether constraints are checked at the statement level (IMMEDIATE) or at the transaction level (DEFERRED)
Whether to enable or disable constraints
Whether to change the filtering mode of constraints.

Syntax

>>-SET CONSTRAINTS---------------------------------------------->
 
>--+-+-ALL--+-IMMEDIATE-+------------------------------------------+-+-><
   | |      '-DEFERRED--'                                          | |
   | | .-,----------.                                              | |
   | | V            |                                              | |
   | '---constraint-+--+-+-IMMEDIATE-+---------------------------+-' |
   |                   | '-DEFERRED--'                           |   |
   |                   |  (1)   .-ENABLED----------------------. |   |
   |                   '--------+-DISABLED--+------------+-----+-'   |
   |                            |           '-WITH ERROR-'     |     |
   |                            |            .-WITHOUT ERROR-. |     |
   |                            '-FILTERING--+-WITH ERROR----+-'     |
   |              (1)   .-ENABLED----------------------.             |
   '-FOR--table---------+-DISABLED--+------------+-----+-------------'
                        |           '-WITH ERROR-'     |
                        |            .-WITHOUT ERROR-. |
                        '-FILTERING--+-WITH ERROR----+-'

Notes:

Informix extension and Dynamic Server only

Element	Description	Restrictions	Syntax
constraint	Constraint whose mode is to be reset	All constraints must exist and must all be defined on the same table	Database Object Name, p. Database Object Name
table	Table whose constraint mode is to be reset for all constraints	Table must exist in the database	Database Object Name, p. Database Object Name

Usage

The SET CONSTRAINTS keywords begin the SET Transaction Mode statement, which is described in SET Transaction Mode. Only Dynamic Server supports the SET Transaction Mode statement, which is an extension to the ANSI/ISO standard for SQL.

The SET CONSTRAINTS keywords can also begin a special case of the SET Database Object Mode statement, which is an extension to the ANSI/ISO standard for SQL. The SET Database Object Mode statement can also enable or disable a trigger or index, or change the filtering mode of a unique index. For the complete syntax and semantics of the SET INDEX statement, see SET Database Object Mode.