Informix Error Messages and Error Codes From Error 8122 to 8126


Informix Error Code -8122 NEED n LINES may not be used in PAGE HEADER or PAGE TRAILER clauses.
1The PRINT statements in a page header or trailer establishes its size. To set a larger size, use PRINT statements with no parameters.
Informix Error Code -8123 The PRINT FILE command is not allowed within the FIRST PAGE HEADER, PAGE HEADER, or PAGE TRAILER clauses.
ACEPREP needs to know how many lines will be filled in header and trailer sections (otherwise, it does not know how many detail rows to put on the page). Because the size of a file cannot be predicted when the report is compiled, the PRINT FILE command is not allowed. You must use PRINT statements to produce the data.

Informix Error Code -8124 A user variable used in the above query has not been defined in the DEFINE section.
A variable that is named in the SELECT statement is not defined in the DEFINE section of the report. Check that all names in the SELECT statement are the ones that you intended and that you have not misspelled any column or variable names.

Informix Error Code -8125 The keyword END was found more than once inside the SELECT section. Within the SELECT section, use semicolons to separate SQL statements. Use the keyword END only after the final SELECT.
Review the contents of the SELECT section to make sure that each SELECT statement except the last one ends in a semicolon and that the last one is followed by an END statement. Perhaps you omitted the FORMAT statement at the beginning of that section.
Informix Error Code -8126 PARAM[0] may not be defined.
The first parameter that you can define in the PARAMETER statement is number 1. In some host-operating systems, the zeroth parameter is preset to the program name, but this value is not available within a report.

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.


Leave a Reply

Your email address will not be published. Required fields are marked *