Informix Error Messages and Error Codes From Error 1817 to 1822


Informix Error Code -1817 No collection or row variable provided.
The host variable used in the derived table syntax is not a collection or row host variable. Check the declaration of this host variable in the application and change it to either a collection or row host variable declaration.

Informix Error Code -1818 Input variable type does not match collection or row definition.
Certain data types cannot be cast on the client. The following situations return this error:
Trying to cast any complex type into any other complex type (that is, casting a set into list)
Trying to cast a built-in type (for example, INT) into a complex type
Trying to cast a complex type into a user-defined data type
Trying to cast a built-in type into a user-defined data type
Check the SQL statement and make sure the types are compatible.

Informix Error Code -1820 Host variable type has been changed between fetches.
If the host variable is used for user-defined-data-type columns or if the host variable itself is a user-defined-data-type host variable, the host variable type and length cannot be changed between fetches.
Informix Error Code -1821 Host variable is not large enough to hold the data returned from the server.
The memory allocated by the application to fetch the user-defined data type is not sufficient. Change the application so that it allocates more memory before it fetches this user-defined data type.
Informix Error Code -1822 Invalid argument.
One of the arguments passed to the function has an illegal value or is NULL. Check the documentation for the valid values that can be passed to this function.

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.