Informix Error Messages and Error Codes From Error 881 to 885


Informix Error Code -881 Resulting string length from TRIM must range from 1 character to 255 characters.
The TRIM function returned a string whose length did not span a range from 1 to 255 characters. The TRIM function returns a VARCHAR string. A VARCHAR string must have a length that ranges from 1 character to 255 characters. Check that the TRIM function returns strings whose length is within that range.

Informix Error Code -882 Cannot create rowids on a non-fragmented table.
You tried to use the ALTER TABLE… ADD syntax to add a rowid column to a table that is not fragmented. This usage is not valid. If a rowid column already exists, rowids already exist on non-fragmented tables.
Informix Error Code -883 Cannot evaluate the fragmentation expression.
A fragmentation expression in your program is invalid. Check the expression, and correct it. Check the logic of that expression. Also, some components of that expression might not represent existing or defined elements such as columns, hash values, ranges, index key values, and so on.

Informix Error Code -884 Cannot alter an index on a temporary table.
Your program attempted to alter an index on a temporary table. Correct your program to avoid altering indexes on temporary tables.
Informix Error Code -885 Invalid or NULL utc time given to dbinfo(utc_to_datetime).
You attempted to pass an invalid or NULL value to the dbinfo() function. Make sure you pass a valid or non-null value to the dbinfo() function.

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 *