Informix Error Messages and Error Codes From Error 9612 to 9620
Informix Error Code -9612 No WHERE, GROUP BY, HAVING or ORDERBY clause is allowed in a collection.
Remove any WHERE, GROUP BY, HAVING, or ORDER BY clause from your statement or remove TABLE(:coll_host_var) from the FROM clause of your statement.
Informix Error Code -9613 Select list cannot have expression when selecting from a collection.
Only ‘*’ or column names are allowed in the select list for derived tables that use collections. Check your SELECT list.
Informix Error Code -9614 Derived column list is not allowed for this statement.
UPDATE statements do not require derived column lists. Columns are listed in parenthesis following a table name. Remove the derived column list from the UPDATE statement.
Informix Error Code -9615 AT keyword is not allowed when inserting in a base table.
Use the AT keyword only when you are inserting into a LIST.
Informix Error Code -9616 Position value should be specified through a constant or a variable.
The position argument for an AT keyword of a LIST must be a simple integer literal, column, or host variable. Simplify the expression to one of these.
Informix Error Code -9617 Source for the SET clause should be a simple expression.
Collection derived tables can only be updated using constants, host variables, or table columns.
Informix Error Code -9618 Aliasing is not allowed for a collection of ROW types.
For collection-derived tables, you need not provide a column name alias. Remove the column name alias.
Informix Error Code -9620 Cannot select the collection variable (collection_variable_name).
This error occurs within SPL when you attempt to place an SPL collection variable in the select list. You must remove the collection variable from the select list.
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.
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.