Informix Error Messages and Error Codes From Error 29084 to 29085


Informix Error Code -29084 Write access is not permitted to data source.
Your application is connected to a database server that supports transactions, but the data source that is being accessed in the statement does not support transactions. In this configuration, non-SELECT SQL statements (that is, actual or potential write operations) cannot be issued to the data source.

In this case, the data source does not have the capability to match the transaction characteristics of the coordinating database server. A write operation cannot be guaranteed to be atomic on the data source (for example, a write to a file might start successfully but eventually fail because of insufficient disk space, leaving the file partially modified). Also, a write operation cannot be rolled back after it has been performed on the data source. For these reasons, write operations are not permitted when the coordinating database server supports transactions (that is, has a log), and the data source does not support transactions.
If distributed write access to the data source is required, access the data source from a non-ANSI database without logging (or that has logging turned off).

Informix Error Code -29085 Cursor hold is not supported by the data source.
The data source does not support cursors that are declared WITH HOLD. Either the target DBMS does not support cursors that remain open after a commit operation, or the ODBC Driver does not use cursors with this property. Cursors that are declared WITH HOLD cannot be used at the data source.

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 *