Informix Error Messages and Error Codes From Error 9846 to 9852

SQLServerF1

Informix Error Code -9846 Operator class operator_class_name does not exist in database.
The operator class used in a CREATE INDEX statement does not exist. Before you can use an operator class, you must create it with a CREATE OPCLASS statement. See informix.sysopclasses for a list of available operator classes.
Informix Error Code -9848 Functional key part cannot use a variant function function_name.
The function used in a CREATE INDEX statement for a functional key part must be a nonvariant function (that is, it must be created with the NOT VARIANT modifier in the CREATE FUNCTION statement).

Informix Error Code -9849 Compare routine routine_name cannot be in SPL
The compare routine used for a generic B-tree cannot be written in SPL. You should rewrite the compare routine in C.
Informix Error Code -9851 Access method access_method_name already exists in database.
The access method that you are creating with a CREATE ACCESS_METHOD statement already exists. You must use a new name.

Informix Error Code -9852 Improper purpose purpose_name used for access method.
A purpose used with the CREATE ACCESS_METHOD or ALTER ACCESS_METHOD statement is improper. It might be spelled incorrectly. Otherwise, it is used incorrectly in combination with the other purposes, or it is a purpose that is not appropriate for the type of access method. For example, an access method cannot be created with AM_DELETE if AM_ROWIDS is not used, and AM_GETBYID cannot be used for a secondary access method. Correct the spelling of the purpose or change one or more of the purposes until the combination of purposes is valid.

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 *