Informix Error Messages and Error Codes From Error 2892 to 2920

SQLServerF1

Informix Error Code -2892 The column column-name name appears more than once. If you wish a column to be duplicated in a form, use the same display field label.
The expected way to display the same column in two or more places is to put two or more fields in the screen layout, each with the same tag-name. Then put a single statement in the ATTRIBUTES section to associate that tag-name with the column name. The current column value will be duplicated in all fields. If you intended to display different columns, the column names as listed in the ATTRIBUTES section must differ. If you intend to display different columns that happen to have the same column-names, prefix each with its table-name.

Informix Error Code -2893 The display field label tag-name appears more than once in this form, but the lengths are different.
You can put multiple copies of a field in the screen layout (all will display the same column), but all copies must be the same length. Review the SCREEN section to make sure that, if you intended to have multiple copies of one field, all copies are the same.
Informix Error Code -2895 Display field length of field-size does not match the database column length of column-size. This is a warning only.
The size of the character field that is defined in this statement (as shown by its appearance in the SCREEN section) is different from the size of the associate column. You specified the -v option to the form compiler to request warnings of this type.

Informix Error Code -2901 Field name contains two conflicting attributes, first and second.
This statement contradicts itself. The UPSHIFT and DOWNSHIFT attributes cannot be applied to the same field; nor can NOENTRY and REQUIRED or NOETNRY and VERIFY. Review the statement, and correct the selection of attributes.
Informix Error Code -2920 The column column is a dominant column but it is not indexed. Performance will be much improved by creating an index on the column.
You have defined the indicated column as dominant in a verify join. Whenever the operator enters a value in the field, it will be looked up in this column. Such a lookup operation is very quick when an index is present. No index on the column exists at this time. Without one, a lookup might be extremely slow. Unless the field does not allow operator input (in which case you should remove the asterisk) or the table is very small (a few dozen rows at most), you should create an index for this column before you put the form into use.

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.

Thanks,
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 *