Informix Error Messages and Error Codes From Error 9983 to 9989

SQLServerF1

Informix Error Code -9983 Deleting a nonexisting element.
You positioned your cursor to an element of a collection that no longer exists and then requested that the element be updated or deleted. This problem occurs if you use a FETCH statement to position your cursor past the last record and then attempt an update or delete. An error results because you are not pointing to a valid record. Make sure your embedded language program is checking the SQLCODE value returned after a FETCH to determine that there are no more rows.

Informix Error Code -9984 Cannot free a collection with other cursor references.
You attempted to free a collection reference while a cursor is still opened on the collection. Review your embedded language program to determine why you are prematurely freeing the collection reference before you close the cursor.
Informix Error Code -9985 Internal Error: invalid change log.
This message indicates an error internal to the support of Informix database server for collection data types. If this error recurs, please note all the circumstances and contact Informix Technical Support.

Informix Error Code -9986 Internal Error: corrupted collection.
This message indicates an error internal to the support of Informix database server for collection data types. If this error recurs, please note all the circumstances and contact Informix Technical Support.
Informix Error Code -9987 Cursor already registered.
You are attempting to open a cursor that is already open. Review your embedded language program to determine why you are re-opening the cursor before you close it.
Informix Error Code -9988 Cannot flatten a collection with other cursor references.
You attempted to store a collection host variable into a table column, or row field, but cursors are still open on the collection. You must close the other cursors before you attempt this operation.
Informix Error Code -9989 Incorrect number of fields in the ROW type.
You attempted to store a row with incorrect field types into a collection. Verify that the row fields match those of 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 *