Informix Error Messages and Error Codes From Error 41021 to 47086


Informix Error Code -41021 Connection Busy.
You are currently making a database server request. You cannot make another argument until the current request is finished.
Informix Error Code -42306 Could not set lock mode to wait.
The utility that you were running could not access the contents of a table because it could not wait for a table lock. Wait a while and retry running dbschema or dbexport.

Informix Error Code -43004 ERROR: where_clause for query exceeds it’s maximum allowed length of maximum_length characters.
No data was passed to the build-where-clause function, so no where clause can be built. The query will proceed without a where clause and will affect all rows in the table.
Informix Error Code -43006 ERROR: Unable to convert datetime to string ESQL_return_value.
Date string is in an invalid format. Consult your Informix manual for the proper ANSI-style date format.

Informix Error Code -43034 ERROR: Unable to update in_time to numeric_value for in_aid numeric_value.
Failure to update the bar_instance table. Ask your database administrator to repair the data.
Informix Error Code -43099 ERROR: Unable to set PDQPRIORITY.
An attempt to change the value of PDQPRIORITY failed.
Informix Error Code -47086 Cannot specify current as default value with non-datetime column type.
You cannot assign a default value consisting of the current time from the system clock when the column data type is not DATETIME. Modify the column data type to DATETIME (if permitted), or specify a different default value for the column.

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 *