Informix Error Messages and Error Codes From Error 2921 to 2933


Informix Error Code -2921 The database dbname is not compatible with the current version of INFORMIX-SQL.
A prior version of Informix software created the database that is named in the DATABASE statement in this form. Before the present system can use the database, you must use the sqlconv utility to convert it.
Informix Error Code -2930 Portions of the column name are displayed on the screen more than once.
This form displays subscripted portions of the indicated column in different fields. This situation is permitted; however, no single character can appear in more than one field. That is, the subscripts cannot overlap. For example, you can display name[25,49] in one field and name[50,74] in another. You cannot display name[25,49] and name[25,74] because some characters would be displayed twice.

Informix Error Code -2931 There is an error in the format specification.
Check the content of the FORMAT string in this statement. It is not correct for the data type; that is, it has characters other than # and . for a numeric column, and it has an incorrect internal length for a DATE column (for example, yyy, which calls for a three-digit year).

Informix Error Code -2932 Formats may be specified only for float, smallfloat, decimal, or date columns.
This attribute statement specifies a FORMAT string, but the data type of the field is not one of the four that support formatting: FLOAT, SMALLFLOAT, DECIMAL (or MONEY), and DATE. If this column is not DISPLAYONLY, check that it has been associated with the right column and that the column is defined in the database as you expected.
Informix Error Code -2933 The format width is larger than the allocated display width.
The length of the FORMAT string that is specified for this field is greater than the length of the field itself as shown in the SCREEN section. Review the screen layout, and revise it or the format so that they agree.

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 *