Informix Error Messages and Error Codes From Error 29053 to 29056


Informix Error Code -29053 Collection missing in the reference to object Object.
Any distributed query that references an OS/400 object must specify the OS/400 collection or library to which the object belongs. The collection or library name should be specified in the owner field of the complete object name database@dbservername:owner.object. The collection or library name is required to get catalog information for the specified Object in a given collection or library.

Informix Error Code -29055 DDL statements are not allowed on a remote object.
In a distributed query, the Gateway does not allow data definition statements and the data access statements GRANT and REVOKE on remote objects (such as objects at DRDA application server sites). Applications can use these statements only when they use the Gateway in direct mode.

Informix Error Code -29056 Gateway cannot rollback savepoint (error-message-info).
An error occurred while a remote distributed update was in progress. Because the Gateway cannot undo the effects of the partial update, the application must terminate the current transaction with a ROLLBACK WORK statement. Any other statement in the current transaction will fail with this error code. If the application issues a COMMIT WORK statement, a ROLLBACK WORK statement is executed internally, and this error code is returned.
The error-message-info field contains the sqlcode of the original error and an optional error messages string if the error originated at the target data source. The format of this message string is documented in the appropriate Gateway user manual. If the error-message-info field is empty, the savepoint rollback is the result of a processing error at the coordinating database server.

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 *