Informix Error Messages and Error Codes From Error 2859 to 2864


Informix Error Code -2859 The column column-name is a member of more than one table — you must specify the table name.
Two or more tables that are named in the TABLES section have columns with the name shown. You must make clear which table you mean. To do this, write the table name as a prefix of the column name, as table.column, wherever this name is used in the form specification.
Informix Error Code -2860 There is a column/value type mismatch for column-name.
This statement assigns a value to the field with the DEFAULT clause or uses its value with the INCLUDE clause, but it does so with data that does not agree with the data type of the field. Review the data type of the field (which comes from the column with which it is associated), and make sure that only compatible values are assigned.

Informix Error Code -2861 You have exceeded the maximum of number tables.
A limit exists on the number of tables that can be in use at one time. (This limit might be different on different host systems or with different database servers.) Reduce the number of tables that you use in the form.
Informix Error Code -2862 The table table-name cannot be found in the database.
All tables used in a form must exist at the time that the form is compiled, so that the compiler can verify the data types of the columns. The indicated table does not exist in the database that is named in the form. Check the spelling of the table name and database name. If they are as you intended, either you are not using the version of the database that you expected (check the value in the DBPATH environment variable), or the database has been changed.

Informix Error Code -2863 The column column-name does not exist among the specified tables.
The tables that are specified in the TABLES section of the form exist, but column-name, which is named in the ATTRIBUTES section, does not. Check its spelling against the actual table. Possibly the table was altered, or the column was renamed. You can use INFORMIX-SQL to check column names under the Tables menu, Info selection.
Informix Error Code -2864 The table table-name is not among the specified tables.
The indicated table is used in this statement but is not defined in the TABLES section of the form specification. Check its spelling; if it is as you intended, add the table in the TABLES section.

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 *