Informix Error Messages and Error Codes From Error 781 to 790


Informix Error Code -781 Cannot alter fragmentation on a temp table.
You tried to alter a fragment that is based on a temporary table. In general, dynamic modification of a TEMP table is not allowed. You must re-create the temporary table if you require a different fragmentation scheme.
Informix Error Code -782 Attached table is fragmented.
When you attach tables, the consumed table cannot be fragmented.
Informix Error Code -783 Cannot attach because of incompatible schema.
Incompatible table schemas do not allow you to perform an attach. When you perform an attach, the table schemas must be identical. Use the ALTER TABLE statement to first make the schemas compatible and then perform an ALTER FRAGMENT…ATTACH operation.

Informix Error Code -784 Cannot detach because of the existing referential constraints.
Existing referential constraints do not allow you to perform a detach. You must drop the referential constraints before you perform the detach on the dbspace or table.
Informix Error Code -785 Cannot drop column because of table or index fragmentation.
You must alter fragmentation expressions to remove references to the column before the column can be dropped.
Informix Error Code -786 Table being attached to is not in the attach list. The surviving table is either nonfragmented or hash-fragmented and must appear in the attach list in order for its existing fragment(s) to be properly positioned in the resulting fragmentation scheme.

Informix Error Code -787 Index fragmented same-as-table cannot be altered.
If you do not specify storage-spec in a CREATE INDEX statement, the indexes are fragmented the same as the underlying table, subject to all the restrictions on fragmented indexes. For example, an error is returned if the underlying fragmentation strategy is round-robin, and the index is unique. You cannot alter this type of index fragmentation. If you want to change the index fragmentation, use the INIT option of ALTER INDEX to detach the index. That operation makes the index and table independent and lets you alter each independently.
Informix Error Code -788 Unknown operator/type.
If you cannot find a direct cause for this internal error, please note all circumstances and contact Informix Technical Support.
Informix Error Code -789 Internal error, expression not properly defined.
If you cannot find a direct cause for this internal error, please note all circumstances and contact Informix Technical Support.
Informix Error Code -790 Rowids already exist on table.
You cannot create rowids multiple times. You attempted to add rowids to a table that was already defined with rowids. Do not run the command that caused this error.

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 *