Informix Error Messages and Error Codes From Error 854 to 862


Informix Error Code -855 Cannot drop rowids on a non-fragmented table.
You tried to use the ALTER TABLE…DROP syntax to drop the rowid column on a table that is not fragmented. A non-fragmented table has a rowid column, but you cannot drop it.
Informix Error Code -856 Rowids already exist on table.
A rowid column already exists for the specified table. You cannot create a rowid for a table more than once. Change your SQL statement.

Informix Error Code -857 Rowids do not exist on table.
You cannot drop a nonexistent rowid. You specified a rowid that does not exist in the specified table. Avoid using rowids in your SQL statement. Instead, use a primary key to delete data.
Informix Error Code -858 Cannot specify the same dbspace twice in a fragmentation specification.
You specified the same dbspace more than once in a fragmentation specification. Change the fragmentation specification to use different dbspaces for each fragment.
Informix Error Code -859 “Distributions Only” is not meaningful in an update statistics LOW request.
You cannot specify the DISTRIBUTIONS ONLY option in the LOW mode of the UPDATE STATISTICS statement.

Informix Error Code -860 A fragmented object must have more than one fragment.
You fragmented an object into one fragment. To put the object in a single dbspace, use the IN clause instead of the FRAGMENT BY clause.
Informix Error Code -861 Cannot create new PDQ thread.
See the accompanying ISAM error for more information.
Informix Error Code -862 Alter fragment attach must have at least one consumed table specified.
You have not specified a table to be consumed. See the syntax and usage for ALTER FRAGMENT… ATTACH in the Informix Guide to SQL: Syntax.

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 *