Informix Error Messages and Error Codes From Error 4429 to 4432

SQLServerF1

Informix Error Code -4429 Report and function parameters cannot be arrays.
You cannot pass a whole array as a parameter of a function. You can pass an individual element of the array by using a subscript. Possibly the array that is causing this error is one component of a record variable that is being passed using asterisk notation. Only 4GL returns this error.
Informix Error Code -4429 Parameters cannot be arrays, records with array members, or constants.
You cannot pass a whole array or a constant as a parameter of a function. You can pass an individual element of an array by using a subscript. Possibly the array that is causing this error is one component of a record variable that is being passed using asterisk notation. Only NewEra returns this error.

Informix Error Code -4430 Values cannot be RETURNed from within reports.
A report cannot include a RETURN statement because that would return control to the routine that invoked the report. Only NewEra returns this error.
Informix Error Code -4430 Record parameters for a report cannot contain elements that are arrays.
You cannot pass a whole array as a parameter of a function. You can pass an individual element of the array by using a subscript. In this case, a record variable is specified as a parameter using asterisk notation, but one of the components of the record is an array.

Informix Error Code -4431 The number of expanded report parameters has exceeded the maximum allowed.
This message is not returned by any current Informix product. If the error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -4432 An element in a GROUP clause must be a member of the ORDER BY clause.
In order to perform grouping, the set of selected rows must be ordered on the same columns. This is the only way to force all the equal values to be found together, as a group. Rewrite the statement so that each selected value that you want to group also appears in an ORDER BY clause. Note that both these clauses allow you to refer to selected values by their position number, as in the following example:
SELECT customer_num, month(order_date), avg(ship_weight) FROM orders
ORDER BY 1, 2 GROUP BY 1,2

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 *