Informix Error Messages and Error Codes From Error 9606 to 9920

SQLServerF1

Informix Error Code -9906 Cannot modify column data type to collection type.
You cannot use an ALTER statement to change a column type to a collection type.
Informix Error Code -9907 Not allowed to modify collection type column.
You cannot use an ALTER statement to change a column type from a collection type to another type.
Informix Error Code -9908 Columns of a row type cannot contain fields of type TEXT, BYTE, SERIAL or SERIAL8.
You created a table that has a column with a named row of type TEXT, BYTE, SERIAL, or SERIAL8. The following example should fail:
create row type rtype (col1 byte); create table tab1 (c1 rtype);
Re-create the table with a different type of named row.

Informix Error Code -9910 Byte, Text, Serial or Serial8 data types in collection type not allowed.
The fields of a row within a collection and the elements of a collection cannot be of type TEXT, BYTE, SERIAL, or SERIAL8.
Informix Error Code -9911 Defaults on collection type column not allowed.
Default values are not supported in the definition a column of a collection type. Remove the default value clause.

Informix Error Code -9912 Constraints on collection type column not allowed.
Constraint expressions are not supported in the definition of a column of a collection type. Remove the constraint clause.
Informix Error Code -9919 Cast already exists in database.
Casts must be unique with regard to their source and destination types, regardless of cast class. Use the DROP CAST statement to remove an existing cast.
Informix Error Code -9920 Cannot create cast between the same type or between two built-in types.
No cast is needed between identical types. Casts between built-in types are handled by internal system casts and cannot be overloaded.

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.

Thanks,
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 *