Informix Error Messages and Error Codes From Error 2970 to 2975


Informix Error Code -2970 The column name joins with other columns, but it is not indexed. It is recommended that columns be indexed for cross-table queries. Performance will be much improved by creating an index.
The presence of an index on at least one of the columns that are involved in a join can make join operation much faster. However, an index is not required when one or both tables are small (dozens of rows). Consider creating an index on all join columns before you put the form into production.
Informix Error Code -2971 This column is not a character column, and therefore cannot be subscripted.
This statement contains a subscript, a pair of numbers in square brackets, after a column name. However, the data type of the column is not CHAR, VARCHAR, or TEXT. Only such columns can be subscripted. Check that you named the correct column. If you did, check its definition in the database.

Informix Error Code -2972 This column cannot be right justified or zero-filled because its displayed width does not match the actual column width.
In order to use the RIGHT or ZEROFILL attributes, make sure that the field size (as depicted in the SCREEN section) is exactly the same as the width of the database column. Review this statement, the screen layout, and the definition of the table in the database to make sure these sizes agree.

Informix Error Code -2973 There may be only one dominant column in a display field description.
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 that precedes a column name indicates that column is the dominant column in a verify join. Only one such column is allowed in any join, but this list contains two or more. Review the documentation on verify joins, and choose a single dominant table.
Informix Error Code -2975 The display field label tag-name has not been used.
The indicated name was defined in the SCREEN section but not in the ATTRIBUTES section. Review the tags in each section, and revise the form so that all tags are defined.

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 *