Informix Error Messages and Error Codes From Error 2831 to 2845


Informix Error Code -2831 The control block has exceeded the maximum of limit fields.
Too many columns or tables are listed in the OF clause of this control block. Write separate control blocks, each for part of the list.
Informix Error Code -2832 This form uses “|” to both start and end a field placement. Because of this, the form must specify left and right delimiters which are the same character. This is done with the DELIMITERS command in the INSTRUCTIONS section.
Make sure that a DELIMITERS statement is present and that it specifies the same character for both left and right delimiters.
Informix Error Code -2834 NULL cannot be used as the default. It is already the default if you specify nothing.
This ATTRIBUTES statement contains a DEFAULT clause that specifies NULL. Either delete the clause, or specify another value.

Informix Error Code -2840 The label tag was not defined in the form.
The indicated name appears at the left of this ATTRIBUTES statement, but it does not appear within brackets in the SCREEN section. Review the field tags that have been defined to see why this one was omitted.
Informix Error Code -2841 The form must include a tables declaration before the attributes section.
Check that the form-specification file contains a DATABASE statement, a SCREEN section, a TABLES section, and an ATTRIBUTES section, in that order.

Informix Error Code -2843 The column column-name does not appear in the form specification.
A name in this ATTRIBUTES statement should have been defined previously in the form specification. Check that all names in the statement are spelled correctly and defined properly.
Informix Error Code -2844 The column column-name is associated with more than one field in the form specification.
Any one table column can be related to only one field in an ATTRIBUTES statement. Possibly you are trying to display columns from two or more tables that have the same column names; in that case, prefix the table names to the column names to distinguish them.
Informix Error Code -2845 The composite column for table table-name containing column column is not indexed. Performance will be much improved by creating an index on the column.
The presence of an index can greatly reduce the time that is needed to join tables. However, an index is not essential, especially when the tables are small, or during initial testing.

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 *