This ddl operation is not allowed due to deferred constraints pending on this table and dependent tables.

Cause

This error is returned when you attempt to start a violations table and constraints are in deferred mode.

Note: No error is returned if you start a violations table and then later set the constraints to deferred. However, the violations get undone immediately rather than written into the deferred constraint buffer. For more information, see the Informix® Guide to SQL: Syntax.

Action

If you would like to start a violations table, you must either change the constraint mode to immediate or commit the transaction.