Informix Error Messages and Error Codes From Error 4120 to 4126


Informix Error Code -4120 Declare variable “name” either external or local to module, but not both.
The specified variable has been declared or defined more than once. At least one of those times declared it with EXTERNAL, and another was a definition as a module variable (lacking either EXTERNAL or GLOBAL). Review the declarations and definitions of name, recalling that some of them might be in included files. If you intend name as a variable private to this module, give it a unique name. (You can declare a variable as EXTERNAL more than once, and you can declare it as EXTERNAL and then define it as GLOBAL. Both of these things can happen as a result of including header files, and they have well-defined meanings. But it is contradictory to have a variable that is both external and local to the module.)

Informix Error Code -4121 Reports cannot be invoked through the CALL statement or in function call expressions.
This statement attempts to call a report as if it were a function. Although a report has the general form of a function definition, it cannot be used like one. Check the names of functions that are called in this statement; one is a report. If you meant to send a row of data to the report, use the OUTPUT TO REPORT statement.

Informix Error Code -4122 Parser limitations have been exceeded. Try to reduce complexity or size of module.
The parser has returned an error that is NOT a syntax error. This error could be caused by a parser-stack overflow (too many levels of nesting within IF statements, WHILE statements, or the like) or by the parser running out of parser-stack space (the module is too large). Try to reduce the complexity of the code by splitting complex functions into multiple functions or splitting the module into multiple modules.
Informix Error Code -4123 CALL to function “name” must have a RETURNING clause.
The function name is declared as returning a result, so the CALL statement must provide a RETURNING clause to receive the result.
Informix Error Code -4125 Not defined/declared as a member in the class hierarchy “name”.
The element indicated is either not declared, or is declared but not defined, as a member of the class hierarchy “name.”
Informix Error Code -4126 Handler expected.
The identifier in the WITH clause of the HANDLE statement does not identify a handler. If the identifier of the handler specifies a class, check to see that the handler is declared as belonging to that class; otherwise, check to see that it is declared as belonging to the declared class of the target object.

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 *