Informix Error Messages and Error Codes From Error 4384 to 4389

SQLServerF1

Informix Error Code -4384 The symbol name does not represent the element of any record.
The name shown is used where 4GL expects the name of a record component. Check the spelling of the name. If it is spelled as you intended, go back to the definition of the record variable and see why it does not include name as a component field.
Informix Error Code -4385 Report aggregates cannot be nested.
Aggregate functions cannot be nested, primarily because the value of the inner aggregate is not known at the time the outer aggregate is being accumulated. Rewrite aggregate expressions to refer only to columns and simple expressions on columns. In an AFTER GROUP OF clause, you can save the aggregate value from one group of rows in a program variable, so as to use it in computing an aggregate over a subsequent group.

Informix Error Code -4386 There are too many ORDER BY fields in this report. The maximum number is number.
A limit exists on the number of ordering fields. You will have to redesign the report so that it requires ordering by no more than number columns. Alternatively you can order the data before passing it to the report, and specify the EXTERNAL keyword on the ORDER BY statement in the report body. It is generally more efficient to have the database server produce the rows in the correct order (using SELECT…ORDER BY in the cursor that produces the rows).

Informix Error Code -4387 The right margin must be greater than the left margin.
If the right margin of a report were no greater than the left margin, there would be no room on each line for data. Check both MARGIN statements in the OUTPUT section for reasonable values.
Informix Error Code -4388 There is one BEFORE GROUP OF clause and one AFTER GROUP OF clause allowed for each report input parameter.
The report is attempting to define a second BEFORE GROUP OF or AFTER GROUP OF block for a single report parameter. Only one such control block is allowed. Find all the block(s) for this parameter, and combine their statements into one.
Informix Error Code -4389 There are too many levels of nesting of IF statements in this report.
You have exceeded the maximum of five levels of nesting of IF statements. Possibly an END IF statement has been omitted. If not, you will have to revise the logic of the report so that decisions are nested less deeply.

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 *