Informix Error Messages and Error Codes From Error 9976 to 9982

SQLServerF1

Informix Error Code -9976 Manipulation of NULL collection disallowed.
You attempted an action on a NULL collection. Examine your embedded language program to determine why you are attempting to operate on a NULL collection.
Informix Error Code -9977 Internal Error: hash value out of sync.
This message indicates an error internal to the support of the Informix database server for collection data types. If this error recurs, please note all the circumstances and contact Informix Technical Support.

Informix Error Code -9978 Insertion of NULL into a collection disallowed.
The elements of a collection must always be non-null. Do not attempt to insert NULL values as elements to a collection. The fields of a row within a collection can be NULL, but the elements of the collection cannot be NULL. The following example is valid for a collection defined with elements of type row. However, insert into table(:coll_hv2) values (NULL) is not valid for any collection.
INSERT INTO TABLE(:coll_hv) VALUES (row(NULL, NULL));

Informix Error Code -9979 Updating of a collection element to NULL is disallowed.
The elements of a collection cannot be NULL. Do not attempt to update collection elements to NULL values. (See the corrective action for error message -9978.)
Informix Error Code -9980 LIST expected when inserting AT position.
You can use a positional insert statement only with collection of type LIST. Remove the AT clause from your insert statement.
Informix Error Code -9981 Delete disallowed on collection with other cursor references.
You attempted to delete a collection that is being referenced by more than one cursor. Review your program, determine the relevant cursor to keep, and remove the other cursor that is acting on the collection.
Informix Error Code -9982 Update disallowed on collection with other cursor references.
You attempted to update a collection that is being referenced by more than one cursor. Review your program, determine the relevant cursor to keep, and remove the other cursor that is acting on the collection.

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 *