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 HCL 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.


Copyright© 2019 HCL Technologies Limited