Informix Error Messages and Error Codes From Error 4062 to 4066

SQLServerF1

Informix Error Code -4062 Warning: Informal function “name” returns (or is expected to return) different number of results at different places.
The function name is called at more than one place in this source module, and it is implied to return different numbers of arguments. Possibly this correct; it is possible to write functions that return different numbers of values in different circumstances. However, you should check that this is the case and that the expected number of values will be returned in each case.

Informix Error Code -4063 Function “name” should not return any results.
This statement invokes the function “name” in a context that implies it should return one or more values. However, that function has been declared earlier in this module without a RETURNING clause or with RETURNING VOID. Make sure that you have called the function you intended; then review its declaration.

Informix Error Code -4064 Type of returned value does not match the declared return type of function “name”.
The function “name” was not explicitly declared but has already been called with one prototype, and the current call provides a different prototype. Make sure that you have called the function you intended. Then review its earlier call, or create an explicit declaration for it.
Informix Error Code -4065 Multiple exception handlers for the same exception class “name”.
Two or more ON EXCEPTION statements exist for the same exception class in this block. Only one can be invoked. Review the statements, make sure that each specifies the correct exception class, and remove or combine duplicate handlers.
Informix Error Code -4066 RETURN statement not allowed in the body of intrinsic functions.
This statement is part of the definition of an intrinsic member function (the class constructor, !copy, and so on). These functions do not have explicit result values; or more precisely, code that the compiler automatically generates produces their returned values. Delete the RETURN statement.

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 *