Informix Error Messages and Error Codes From Error 29082 to 29083

SQLServerF1

Informix Error Code -29082 Could not decode field value for field number field-number.
In the row that is being fetched, the field value for the field that is numbered field-number could not be decoded and converted into an Informix data value. The field number is the ordinal position of the field that could not be converted in the select list. This situation reflects an error in the ODBC Driver for the target DBMS. The field value that could not be decoded is written to the Gateway log file along with the Driver Name and Version information.
Contact your ODBC Driver supplier for a solution to the problem.

Informix Error Code -29083 Compatible isolation level not supported by the data source.
If you received this error code when you executed a SET ISOLATION TO statement, the attempt to set the isolation level at the data source to a level compatible with the level in the statement has failed. The current isolation level in your application remains in effect.
If you receive this error code when you are executing a distributed SQL statement, the statement has failed because the data source does not support an isolation level that is compatible to the current isolation level of your application. The current isolation level in your application remains in effect.

A compatible isolation level is equal to or higher than the requested (or current, if a distributed statement) isolation level. When the requested (or current) isolation level is supported at the data source, Informix Enterprise Gateway Manager sets the data-source isolation level to that level. When the requested or current isolation level is not supported at the data source, if any higher levels are supported, Informix Enterprise Gateway Manager sets the data-source isolation level to the next available higher level.

If a lower isolation level that the data source supports is acceptable to your application, set the isolation level to that lower level. If you are accessing Informix Enterprise Gateway Manager in direct access mode, use the GWDIRECTMIL environment variable to set the isolation level. If you are accessing Informix Enterprise Gateway Manager in distributed-access mode, issue the SQL statement SET ISOLATION TO before you execute the distributed statement that accesses the Gateway.

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 *