Informix Error Messages and Error Codes From Error 2846 to 2858


Informix Error Code -2846 The field field-name is not a member of the table table-name.
Something in this statement suggests that the name shown is part of this table, but that is not true in the current database. Review the spelling of the two names. If they are as you intended, check that the correct database is in use and that the table has not been altered.
Informix Error Code -2850 The name name is not a column name in this database.
The tables that are specified in the TABLES section of the form exist, but the 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 -2856 The TODAY attribute may be assigned only to date columns.
The TODAY function (not attribute) returns the value of today’s date. That value can be assigned only to a field that has the DATE or DATETIME data type. The field in this statement has a different type. Automatic data conversion is provided in 4GL programs, but not in the context of a form.

Informix Error Code -2857 There can be only one dominant composite column in a join list.
This statement defines a join list, a list of two or more column names that are related to the same form field. In such lists, an asterisk preceding a column name indicates that column is the dominant column in a verify join. Only one such column is allowed in any join, but two or more are present in this list. Review the documentation on verify joins, and choose a single dominant table.

Informix Error Code -2858 The table table-1 is joined to the table table-2, but its joined columns do not belong to a composite key.
You have defined two or more different joining columns between the two indicated tables. However, no composite index exists on the joining columns. Such an index is required to ensure that a composite key exists; that is, that any combination of values from the joining columns will occur only once. Review the two or more ATTRIBUTES statements that define join columns for these two tables. Make sure that they are as you intended; for example, make sure that you intended to join two tables on two or more columns, instead of joining three or more tables on one column each. If you intended the composite key, then use the CREATE INDEX command to create a composite unique index on those columns for at least table1.

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 *