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


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 IBM® Informix® Guide to SQL: Syntax.


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

Copyright© 2018 HCL Technologies Limited