Informix Error Messages and Error Codes From Error 896 to 903


Informix Error Code -896 Violations table is not started for the target table.
If a violations and diagnostics table has not been started for the target table, and an INSERT, DELETE, or UPDATE statement fails to satisfy any filtering-mode object on the target table, the user who issued the INSERT, DELETE, or UPDATE statement receives this message.
To recover from this error, you must start a violations and diagnostics table for the target table. Then, when users issue INSERT, DELETE, or UPDATE statements that fail to satisfy filtering-mode objects that are defined on the table, they do not receive this message.

Informix Error Code -897 Cannot modify/drop a violations/diagnostics table.
The user has tried to alter or drop a table that is serving as a violations table or a diagnostics table for another table.
-898 Cannot alter a table which has associated violations/diagnostics tables.
The user has tried to add, drop, or modify a column in a table that has a violations and diagnostics table associated with it.

Informix Error Code -899 Too many violations.
The number of records in the diagnostics table either exceeds or will exceed the limit that is specified in the MAX ROWS clause of the START VIOLATIONS TABLE statement. When a single statement on the target table (such as an INSERT or SET statement) causes more records to be inserted into the diagnostics table than the limit that is specified by the MAX ROWS clause, this error is returned to the user who issued the statement on the target table.
Informix Error Code -903 Licensed INFORMIX-SQL server not accessible.
This statement refers to another host computer system, and that system is active and accessible. However, the sqlexecd network daemon has not been started on it, so no database services can be gotten from it. Contact the DBA of the other system. Check that the INFORMIX-STAR or INFORMIX-NET software is correctly installed.

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 *