Informix Error Messages and Error Codes From Error 9869 to 9905

SQLServerF1

Informix Error Code -9869 Cannot drop access method access_method_name: still in use.
A DROP ACCESS_METHOD statement cannot be used if any tables or indexes are defined using that access method. Drop the tables or indexes first and then drop the access method.
Informix Error Code -9870 Cannot alter access method access_method_name: still in use.
An ALTER ACCESS_METHOD statement cannot be used while anyone is using the access method. Wait until no one is using the access method and try again.

Informix Error Code -9871 Alter fragment attach/detach for external table not supported.
The ALTER FRAGMENT statement cannot be used for a table or index that uses an access method. Either create a new table with the desired properties and copy the data from the old table to the new table or create a new index with the desired properties.
Informix Error Code -9872 Cannot drop operator class operator_class_name: still in use.
The operator class is being used in an existing index and therefore cannot be dropped. Drop all the indexes that use the operator class before you drop it.

Informix Error Code -9873 Not owner of operator class.
You cannot drop an operator class unless you are the owner or the database administrator. Contact the database administrator or the owner of the operator class.
Informix Error Code -9904 Invalid extended type text.
Could not determine the internal SQL data type. If this error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -9905 No extended type information for domain.
Could not find the attribute information for a domain or type. If this error recurs, please note all circumstances and contact Informix Technical Support.

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 *