Informix Error Messages and Error Codes From Error 9704 to 9709


Informix Error Code -9704 For SPL routine, parameter must be named.
The name of the parameter in a CREATE FUNCTION or CREATE PROCEDURE statement is optional only for external routines. Specify the parameter name.

Informix Error Code -9705 These modifiers are invalid for SPL routines: CLASS, CLIENT, HANDLESNULLS, INTERNAL, ITERATOR, PERCALL_COST, SELFUNC and STACK.
Do not specify these modifiers for SPL routines.
Informix Error Code -9706 END PROCEDURE/FUNCTION does not match with CREATE PROCEDURE/FUNCTION.
If you are using a CREATE PROCEDURE statement, the end clause must contain END PROCEDURE. If you are using a CREATE FUNCTION statement, the end clause must contain END FUNCTION. Do not mix and match PROCEDURE and FUNCTION keywords.

Informix Error Code -9707 Modifiers COMMUTATOR and NEGATOR are not allowed in procedure.
Because procedures do not return values, these modifiers are not allowed in a CREATE PROCEDURE statement. Use a CREATE FUNCTION statement or do not specify these modifiers.
Informix Error Code -9708 SELFUNC modifier can only be used in EXTERNAL FUNCTION.
Do not specify SELFUNC modifier to a SPL routine or an external procedure.
Informix Error Code -9709 More than one distinct type of the parameter type have cast to argument type.
This situation occurs if more than one distinct type of the source type of the parameter has casts from the argument type. For example, assume the routine routine_name(paramtype) exists. Both paramdist1 and paramdist2 are distinct types of paramdist1. The routine is invoked as routine_name(argtype). Casts also exist from argtype to paramdist1 and argtype to paramdist2. Because distinct types inherit all the routines defined on the source types, paramdist2 and paramdist1 inherit the routine routine_name. Thus the routine resolution cannot resolve the routine, and this error results.

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 *