Informix Error Messages and Error Codes From Error 886 to 892


Informix Error Code -886 Cannot drop table or view because of existing dependencies.
When you issue a DROP TABLE or DROP VIEW statement, you cannot drop the table or view if you specify the RESTRICT option and a view or foreign-key constraint exists that depends on that table or view.
You also cannot drop a table if you specify the RESTRICT option and a violations and diagnostics table exists for that table.

Informix Error Code -887 Cannot revoke because of dependent privileges, views, or constraints.
You cannot use the RESTRICT option to REVOKE a privilege if that action will cause abandoned privileges, abandoned views, or abandoned table constraints. Refer to the Informix Guide to SQL: Tutorial for more information.
Informix Error Code -888 Cannot attach a table with constraints.
You attempted to attach a table that had constraints. Remove all referential and primary constraints from that table, and attempt an attach.

Informix Error Code -889 Internal dataskip condition, should reposition to next row and continue.
If this internal error recurs, please note all circumstance, and contact Informix Technical Support.
Informix Error Code -891 Temporary table objects can only be enabled.
You cannot change the object mode of a temporary table object to the disabled or filtering object mode.
Informix Error Code -892 Cannot disable object object-name due to other active objects using it.
Other objects are using this object. If the object being disabled is an index, then a unique constraint, primary constraint, or referential constraint might be using that object. If the object is a unique or a primary-key constraint, then a referential constraint might be using that object.

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages received while performing certain operation against Informix applications or related products.

What are Informix Error Messages?
All Informix messages returned by the Informix server are assigned an error code.

In general, each Informix error contains the following information:
• The Informix Error Code or Informix Error status
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

SQLServerF1 Team
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *