Informix Error Messages and Error Codes From Error 937 to 946


Informix Error Code -937 User Defined Routine error.
mi_db_error_raise() has been called from within a user-defined routine and set a fatal error. For an explanation, look at the SQLSTATE that the user- defined routine set.
Informix Error Code -940 Check Option is not supported in Union Views.
You tried to define a union view with a check options. Redefine the union view without the check options clause.

Informix Error Code -941 String processing error while evaluating function (function_name).
An error occurred during evaluation of the case conversion function on the input string. This error could be due to an invalid character (single- or multi-byte) in the string. You need to execute the query again after verifying that the characters in the input string are valid.
Informix Error Code -942 Transaction commit failed – transaction will be rolled back.
This error can occur at transaction-commit time if an error is raised when a DataBlade routine calls a UDR-registered end-of-transaction (MI_EVENT_END_XACT) callback. You have registered a callback for the MI_EVENT_END_XACT (or MI_Xact_State_Change) event in the context of a server routine. When the end-of-transaction (MI_EVENT_END_XACT) event occurred to commit the transaction, an error was raised. Within a DataBlade routine, you can use the mi_err_desc_next() function to obtain the next error, which should explain the cause of the failure. Currently, the end-of- transaction (MI_EVENT_END_XACT) event occurs only within the context of a DataBlade server routine. It does not occur within the context of a DataBlade client application.

Informix Error Code -945 Invalid or NULL parameter given to dbinfo(version).
You entered a value for a version that this command does not support.
Informix Error Code -946 Source string for UPPER, LOWER, and INITCAP must be of string type.
The source string passed as input to a case conversion function must have a character data type.

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 *