Informix Error Messages and Error Codes From Error 9990 to 1101


Informix Error Code -9990 Cannot drop named row type row_type_name: still in use.
The row type that you are attempting to drop is being referenced by another type of table. First drop the type of table that refers to this type.
Informix Error Code -9991 Named row type row_type_name already exists in database.
You are trying to create a named row type whose name is already used. Use another name or drop the row type to reuse its name.
Informix Error Code -9992 Named row type row_type_name not found.
The named row type specified does not exist in the database. Verify its existence by selecting from sysxtdtypes.

Informix Error Code -9993 Not owner of named row type.
You cannot drop the named row type unless you are the owner or have the DBA privilege. Verify the owner of the named row type by selecting from sysxtdtypes.
Informix Error Code -9994 Cannot use ONLY(TABLE(str)) over collections.
The ONLY syntax is not legal over TABLE expressions over collections. Use ONLY on supertables; that is, parents in an inheritance chain.

Informix Error Code -9995 Table table_name is not typed.
Cannot alter a table to drop its type if the table is not typed. Make sure you are referring to the correct table.
Informix Error Code -11001 General warning.
This CLI warning can be returned with any CLI function except SQLAllocEnv and SQLError when a nonspecific warning occurs. Additional text is appended to describe the specified warning in more detail. For detailed information associated with the appended text, check the INFORMIX-CLI Programmer’s Manual.

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 *