Informix Error Messages and Error Codes From Error 869 to 875


Informix Error Code -869 Subqueries and procedures not allowed in fragmentation expressions.
A fragmentation expression can reference only columns from the current table and data values from a single row. The restrictions disallow subqueries, stored procedures, current date/time functions, user-defined routines, and aggregates.
Informix Error Code -870 Cannot specify duplicate remainder fragments.
You specified duplicate remainder fragments. Remove one of the remainder fragments from your SQL statement.
Informix Error Code -871 Remainder fragment must be specified last.
If you specify a REMAINDER, it must be the last fragment expression. Rewrite your syntax so that you specify the remainder fragment last.

Informix Error Code -872 Invalid fragment strategy or expression for the unique index.
The round-robin method cannot fragment unique indexes. If the expression method fragments the indexes, all the columns that are used in the fragmentation expressions must also be part of the index key.
Informix Error Code -873 Invalid fragment expression column.
You cannot use columns from different tables in a fragment expression.

Informix Error Code -874 Floating point exception error has occurred.
This internal error affects the cost calculations that the query optimizer makes. If the error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -875 Incompatible Access Mode and Isolation Level.
If you set the access mode to READ-WRITE, you cannot set the isolation level to READ-UNCOMMITTED.

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 *