Informix Error Messages and Error Codes From Error 9922 to 9960


Informix Error Code -9922 Cast does not exist in database.
The requested cast does not exist. Use the CREATE CAST statement to define the cast.
Informix Error Code -9923 Cannot create cast between incompatible types.
An attempt was made to define a no-function cast between types with differing representations. Redefine the cast to use a function or redefine the types so that they share the same representation.

Informix Error Code -9926 The “order by,” “distinct,” index, union and primary/foreign/unique key constraints are not allowed on row-type columns.
Do not create or alter a table with columns of row type that contain primary key, foreign key, or unique constraints. Do not create an index or union that involves row-type columns. However, you can create a union that involves row-type columns if you use the UNION ALL statement instead of the UNION statement.

Informix Error Code -9944 Cannot seek in non-scrollable collection.
You have opened a collection with the flags MI_COLL_NOSCROLL and later attempted to seek within the collection. Open the collection without this flag or do not attempt to seek within the collection.
Informix Error Code -9945 Cannot modify a read only collection
You have opened a collection with flags MI_COLL_READONLY and then attempted to modify the collection. Do not open the collection with this flag or do not modify the collection.
Informix Error Code -9946 Cannot open subquery collection twice.
Subquery collections opened with the flags MI_COLL_READONLY and MI_COLL_NOSCROLL cannot be opened again.
Informix Error Code -9960 Combination of table/index fragmentation not allowed.
If a table is fragmented by round-robin and its subtable specifies its own fragmentation scheme, you cannot create an index on the supertable without a fragmentation clause. Either create an index with an explicit fragmentation clause or let the subtable inherit its fragmentation scheme from the supertable.

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 *