Informix Error Messages and Error Codes From Error 9700 to 9703

SQLServerF1

Informix Error Code -9700 Routine (routine_name) ambiguous – more than one routine resolves to given signature.
This problem happens when an argument (or its source type or parent type) has implicit casts to the parameters of two or more routines.
For example, assume two routines exist called routine_name(paramtype1) and routine_name(paramtype2), and routine_name is invoked with routine_name(argtype). Also, implicit casts exist from argtype to paramtype1 and argtype to paramtype2. In this case, this error is raised.
The error is also raised, if instead of argtype, argtype_dad which is in the source type hierarchy of argtype (if argtype is a distinct type) or in the super type hierarchy of argtype (if argtype is a row type) has casts to paramtype1 and paramtype2.
You will need to redefine the implicit casting scheme, such that only one casts exists from argtype to either paramtype1 or paramtype2 or remove one of the routines.

Informix Error Code -9701 An EXTERNAL PROCEDURE cannot have RETURN clause.
Do not specify the returns/returning clause to a PROCEDURE that is an external procedure. You can specify this clause for a SPL procedure, but specifying a RETURN clause to a procedure is highly discouraged.

Informix Error Code -9702 When a FUNCTION is created, the RETURN clause must be specified.
All functions must return a value. Specify a return clause or use a CREATE PROCEDURE statement.
Informix Error Code -9703 Modifiers VARIANT and NOT VARIANT cannot be used in the same routine.
Either VARIANT or NOT VARIANT can be specified either as a modifier or as a clause after the LANGUAGE clause. If both are specified, they must both be specified as VARIANT or as NOT VARIANT. Either make them consistent or remove one of the references as a modifier or as a clause after the LANGUAGE clause.

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 *