Informix Error Messages and Error Codes From Error 2865 to 2890


Informix Error Code -2865 The column column-name does not exist in the table table-name.
Something in this statement implies that the column shown is part of the indicated table (most likely the statement refers to table-name.column). However, it is not defined in that table. Check the spelling of both names. If they are as you intended, then check the contents of the database; possibly the table has been altered or the column renamed.
-2866 The NOW attribute may be assigned only to datetime columns.
This message is not in use in any current product. SQL does not support any NOW attribute or function; use the CURRENT function.

Informix Error Code -2867 The CURRENT attribute may be assigned only to datetime columns.
The CURRENT function (not attribute) produces the current date and time as a DATETIME value, but the field that is referenced in this statement does not have the DATETIME data type. Automatic data conversion is not supported in this context. Review the statement to make sure that it refers to the field that you intended, and revise the form to assign DATETIME values only to DATETIME fields.
Informix Error Code -2870 The subscripted column size does not match the space allocated in the display field.
This attribute statement relates a substring of a column to a display field. However, either the substring numbers are wrong (the first is less than 1 or greater than the size of the column, the second is less than the first), or they are correct but the number of characters that they select is different from the size of the display field. Revise the substring numbers to select exactly as many characters as the field requires.

Informix Error Code -2880 The word ‘screen’ or ‘end’ has been left out.
Every form specification must end in the keyword END and must contain the keyword SCREEN. Both must begin in the first column of a line. Review the contents of the form specification to make sure that all the necessary sections are properly marked.
Informix Error Code -2890 A screen definition must begin with a left curly bracket ‘{‘.
Each screen layout must be enclosed in braces ({ }). The open brace must be the first character on its line. Review the form specification to make sure that the screen layout is punctuated properly.

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 *