Informix Error Messages and Error Codes From Error 8127 to 9001


Informix Error Code -8127 You cannot use more than one REPORT TO statement in a report specification.
The entire report is directed to one destination, which is chosen with the REPORT TO statement in the OUTPUT section. The report cannot be divided between multiple destinations, so remove all REPORT TO statements after the first. If you want to produce separate report files for different sets of data, perform one of the following steps:

Write a separate report for each set of data (the specifications should differ only in their SELECT statements).
Produce a full report, but with sets of data on separate pages, and use operating-system utilities and tools to separate the files afterward.
Use parameter variables in the SELECT statements so that you can choose a subset of data dynamically, when you run the report, and use REPORT TO PRINT so that you can set the DBPRINT variable to control the output destination before you start the report.
Informix Error Code -8128 Minimum length of a VARCHAR variable must be smaller than the maximum size.
A VARCHAR variable is defined with the two numbers name(n,r), where n is the maximum length of the variable and r is the reserved length. The reserved length is meaningful only in the context of a database table definition, although it is allowed when you define a report variable. If you specify it, you must write a number for r that is less than or equal to the size, n.

Informix Error Code -8129 Specified page length length is too short for default report.
A report page cannot fit in the number of lines that are specified. Allow more lines per page or revise the report specification to use fewer lines (for instance, by changing the top or bottom margins).
Informix Error Code -8130 An INTEGER constant may not be larger than 2147483647.
This statement specifies a value that cannot be contained in an integer. Either use a smaller value or a different data type (for example, DECIMAL).
Informix Error Code -9001 Only columns of type CHARACTER may be subscripted or printed without trailing blanks.
Either you attempted to subscript or apply the CLIPPED function to a noncharacter variable, or you specified a variable to have the wrong data type.

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 *