Informix Error Messages and Error Codes From Error 9859 to 9868

SQLServerF1

Informix Error Code -9859 Index not created because its access method doesn’t support unique keys.
A CREATE UNIQUE INDEX statement used an access method that does not support unique keys. Remove UNIQUE.
Informix Error Code -9860 Improper access method used.
A CREATE TABLE statement used a secondary access method or a CREATE INDEX statement used a primary access method. Use a primary access method with CREATE TABLE and a secondary access method with CREATE INDEX.

Informix Error Code -9861 Improper access method parameter information used for an external table/index.
A CREATE TABLE or CREATE INDEX statement is using an access method with parameter information that is improper. For example, the identifier might be longer than 18 bytes, or the value might be longer than 236 bytes. Correct the parameter information.
Informix Error Code -9862 Could not initialize or execute access method routine.
An access method routine failed to execute properly. The RSAM error code gives more information.

Informix Error Code -9863 Opclass opclass_name already exists in database.
The opclass being created with a CREATE OPCLASS statement already exists. Use a new name.
Informix Error Code -9864 Improper strategy definition.
A CREATE OPCLASS statement is using a strategy definition that is improper. For example, a strategy might take at most three arguments. Correct the strategy definition.
Informix Error Code -9865 Improper support definition.
A CREATE OPCLASS statement is using a support definition that is improper. For example, a support name can be at most 18 bytes. Correct the support definition.
Informix Error Code -9867 Access method access_method_name not found.
A DROP ACCESS_METHOD or ALTER ACCESS_METHOD statement uses an access method that does not exist. Use the correct access method.
Informix Error Code -9868 Not owner of access method.
The person executing a DROP ACCESS_METHOD or ALTER ACCESS_METHOD statement is not the owner of the access method or does not have DBA privileges.

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 *