Informix Error Messages and Error Codes From Error 4078 to 4085


Informix Error Code -4078 Operand is missing, or is of a type that is not supported.
The operator has been directed to operate on an invalid type. Perhaps a function returns VOID, a blob (TEXT or BYTE), or FOREIGN result. IS NULL and IS NOT NULL operators can operate upon TEXT or BYTE and FOREIGN operands and can receive assignment from other operands of the same type or NULL.
Informix Error Code -4079 Operation is not allowed in index expressions.
An operation such as expansion (.*), COPY, NEW, or THRU was attempted in an index expression.

Informix Error Code -4080 Warning: Operation on NULL returns NULL.
While the compiler was optimizing expressions, it found an expression composed of literal values, at least one of which was NULL.
Informix Error Code -4081 Warning: A DATETIME expression cannot be negative.
A “-” operator occurred with a DATETIME operand. No negative points exist in time. INTERVAL can be negative, but DATETIME cannot. Inspect the syntax of the expression, and revise it to make it greater than or equal to zero.

Informix Error Code -4082 Operands of MATCH and LIKE operations must be of CHAR or VARCHAR type.
This statement uses the MATCH or LIKE operator with an argument expression that is numeric or binary. No automatic conversion of data types exists in this case. Examine the expression. If it is written as you intended, revise it to assign the values to character variables (thus forcing their conversion to character) before you use them with MATCH or LIKE.
Informix Error Code -4083 Warning: Initialization of external variable(s) will be ignored.
This is only a warning. This statement declares a variable with both the EXTERNAL keyword and an initialization expression. You can initialize a variable only at the point where it is defined (that is, where memory is allocated for it). This is a declaration, not a definition, so the initialization is ignored.
Informix Error Code -4085 Cannot output expression of this type.
The statement attempted to output an expression of a type that cannot be output, such as FOREIGN, or an expression that includes an invocation of a function that returns VOID.

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 *