Informix Error Messages and Error Codes From Error 9853 to 9858

SQLServerF1

Informix Error Code -9853 Duplicate purpose purpose_name used for access method.
A purpose used with the CREATE ACCESS_METHOD or ALTER ACCESS_METHOD statement has been used more than once. Change the purposes used until no duplicates exist.
Informix Error Code -9854 Required purpose purpose_name not used for access method.
A required purpose has not been used with the CREATE ACCESS_METHOD statement, or a required or default purpose has been removed with the ALTER ACCESS_METHOD statement. For example, AM_SCANCOST has a default value if not used with the CREATE ACCESS_METHOD statement, but it cannot be dropped with the ALTER ACCESS_METHOD statement. Change the purposes used until the required purposes are included or preserved.

Informix Error Code -9855 Improper value used for purpose purpose_name for access method.
A purpose has been used with an improper value in a CREATE ACCESS_METHOD or ALTER ACCESS_METHOD statement. For example, an integer cannot be used for AM_SPTYPE. Use the proper type of value for the purpose.

Informix Error Code -9856 Index not created because the table’s access method doesn’t support rowids.
A CREATE INDEX statement was used on a table whose access method does not support rowids. Because rows from the table are fetched by the index by rowid, the index cannot be created.
Informix Error Code -9857 Unknown space space_name used for external table/index.
A CREATE TABLE or CREATE INDEX statement has an IN clause that references an extspace that does not exist. Use an existing extspace.
Informix Error Code -9858 Unsupported option option_name used for an external table/index.
An ALTER TABLE or ALTER INDEX statement has an option that is not supported by the access method. Remove the option.

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 *