Informix Error Messages and Error Codes From Error 9641 to 9651


Informix Error Code -9641 Drop type can only drop opaque type or distinct type.
The DROP TYPE statement applies to opaque and distinct types only. Use DROP ROW TYPE statement to drop row types.
Informix Error Code -9642 A quoted string exceeds 32,768 bytes.
The system imposes a limit of 32,768 bytes on quoted strings. You cannot exceed this limit.

Informix Error Code -9643 Type (type_name) is not hashable.
Hashing is used in GROUPBY statements and as a mechanism to eliminate duplicate values in DISTINCT and UNION clauses. You cannot use types declared as non-hashable in these statements.

Informix Error Code -9645 Cannot execute cast from user-defined type to character format.
When you use the debugging feature of SPL to print the content of a user-defined, data-type variable, this error occurs if the database server cannot find or execute the cast function to convert from the given user-defined data type to character or long format.
Informix Error Code -9646 Result of a Boolean expression is not of Boolean type.
When a conditional expression, such as a WHERE clause or an IF clause, is evaluated in this statement, the result is not a Boolean value. All conditional expressions must evaluate to a Boolean value, so check that all conditional expressions evaluate correctly. If the expression does not, use appropriate casts to make it evaluate properly.
Informix Error Code -9651 Blobs are not allowed in the “Union” clause. You selected a TEXT or BYTE column in a UNION query. The SELECT clause of each query cannot include any TEXT or BYTE columns. These columns are not allowed in a UNION clause because TEXT and BYTE columns cannot be tested for equality. A UNION ALL clause, however, can include TEXT and BYTE columns (in a standalone SELECT statement or in a UNION view).

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 *