Syntax options:

       SQLOPTIONS= (CONSTRAINT_MODE=IMMEDIATE)
       SQLOPTIONS= (CONSTRAINT_MODE=DEFERRED)
       SQLOPTIONS= (CONSTRAINT_MODE=ON)
       SQLOPTIONS= (CONSTRAINT_MODE=OFF)

    You can optionally specify either the SQLOPTIONS=(CONSTRAINT_
    MODE=IMMEDIATE) or SQLOPTIONS=(CONSTRAINT_MODE=DEFERRED)
    qualifier on the SQL precompiler command line to set the
    default constraint evaluation mode for commit-time constraints.
    (This qualifier does not affect the evaluation of verb-time
    constraints.) The default is DEFERRED; that is, commit-time
    constraints are evaluated at commit time.

    Setting constraints IMMEDIATE causes each affected constraint
    to be evaluated immediately, as well as at the end of each
    statement, until the SET ALL CONSTRAINTS DEFERRED statement
    is issued, or until the transaction completes with a commit or
    rollback operation.

    The SET ALL CONSTRAINTS statement overrides the constraint
    evaluation mode specified in the SQLOPTIONS qualifier. For more
    information about the default constraint mode, see the Oracle Rdb
    SQL Reference Manual.

    SQL users who require ANSI-standard SQL compatibility should set
    constraints as IMMEDIATE. The default (CONSTRAINT_MODE=DEFERRED)
    is acceptable for most other users.

    The qualifiers CONSTRAINT_MODE=ON and CONSTRAINT_MODE=OFF
    duplicate the behavior of the qualifiers CONSTRAINT_
    MODE=IMMEDIATE and CONSTRAINT_MODE=DEFERRED, respectively.