Informix Error Messages and Error Codes From Error 9631 to 9640


Informix Error Code -9631 Opaque type (type_name) already exists in database.
Opaque types must be unique within the schema (ANSI mode) or database. Be sure that the type does not already exist.
Informix Error Code -9632 Value does not match the type of column (column_name).
Automatic conversions between data types require implicit casts. Use the CREATE IMPLICIT CAST statement to define a cast between the source and destination types.
Informix Error Code -9633 ALTER TABLE cannot modify column (column_name) type. Need a cast from the current type to the new type.
Conversions of column types require a cast. Use the CREATE CAST statement to define a cast from the source to destination type.

Informix Error Code -9634 No such cast.
The specified cast does not exist. Use the CREATE CAST statement to define the cast.
Informix Error Code -9635 Illegal attempt to convert an opaque type into another type.
You should not encounter this error. If this error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -9636 Opaque type exceeded its maximum length.
Opaque types are defined with a maximum length that cannot be exceeded. Verify that user-defined routines that return the type do not attempt to exceed the size limit.

Informix Error Code -9637 Cast function (function_name) does not exist.
The function associated with a cast must exist when the cast is executed. Use the CREATE FUNCTION statement to create the function.
Informix Error Code -9638 Grant/Revoke under on opaque types disallowed.
The UNDER clause in the GRANT/REVOKE statements applies to row types only. It cannot be used with opaque types.
Informix Error Code -9639 Grant/Revoke under on distinct of non-row types disallowed.
The UNDER clause in the GRANT/REVOKE statements applies to row types (and distinct of row-types) only. You cannot use the UNDER clause with non-row types or distinct of non-row types.
Informix Error Code -9640 Cannot drop type (type_name): distinct type defined over the type.
Before you can drop a type, you must first drop all distinct types based on the type.

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.