Informix Error Messages and Error Codes From Error 9710 to 9715

SQLServerF1

Informix Error Code -9710 Overloading of built-in functions is not allowed.
Built-in functions such as dbinfo and trim should not be overloaded. Change the name of the routine that you are creating so that it does not conflict with the names already used in the database server.
Informix Error Code -9711 Late bound functions cannot have different number of return values
Due to late binding, the function that is executed could change in the middle of query execution. This error is called if the number of values returned by the new function is not the same as the previous function. All functions with the same name defined over a type hierarchy should have the same number of return values.

Informix Error Code -9712 Late bound functions cannot have different return types.
Due to late binding, the function that is executed could change in the middle of query execution. This error results if the type of values returned by the new function is not the same as the previous function. All functions with the same name defined over a type hierarchy should have the same type of return values.

Informix Error Code -9713 Identifier too long – maximum allowed length for this identifier is 128.
The specific name specified in the CREATE PROCEDURE or CREATE FUNCTION statement is longer than 128 bytes. Shorten the name.
Informix Error Code -9714 OUT parameter can only be the last parameter of a routine.
When an OUT parameter is specified in the CREATE FUNCTION statement, it must be the last parameter and the only parameter with the OUT option.
Informix Error Code -9715 A procedure cannot have any OUT parameters.
A CREATE PROCEDURE function cannot have OUT parameters. Only a CREATE FUNCTION statement can have OUT parameters in the parameter. The parameter specified as OUT should be the only and last parameter.

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 *