Informix Error Messages and Error Codes From Error 9065 to 9070


Informix Error Code -9065 Memory allocation has failed.
ACEGO was unable to allocate memory to hold a row, a line, or an SQL data structure. The space needed is not (as the message text suggests) directly related to the size of the report specification. The report lacks only a few thousand bytes, at most, to run.
Informix Error Code -9066 An error has occurred while writing to the output report.
The report destination was opened correctly, but the operating system reported an error while output was being written. Look for error messages from the operating system that explain the problem. The most common cause of the error is lack of available disk space.

Informix Error Code -9067 ACEs arithmetic stack has exceeded its bounds. The expression here is too complicated.
Reduce the complexity of the arithmetic expression. For example, divide the expression into subexpressions and assign the values of each to a variable.
Informix Error Code -9068 An SQL statement has been found in the SELECT section that is not a SELECT statement. Only SELECT statements or SELECT statements that create temporary tables are allowed in the SELECT section.
Possibly the word SELECT is misspelled in the report specification. If you intentionally wrote another SQL statement such as UPDATE or INSERT, remove it; only SELECT statements are permitted in reports. (You can execute other SQL statements in a C function that is called from a report. The ESQL/C manual discusses linking external C functions with reports.)

Informix Error Code -9070 A record in the flat ascii input file contains more data fields than what was specified in the DEFINE ASCII statement of the report.
A field in the ASCII file is a sequence of zero or more characters that ends in a delimiter character (the delimiter is specified in the READ statement). Effectively, as many fields as delimiter characters exist in each record. The number of fields must be the same in each record, and each field must be defined in an ASCII statement in the DEFINE section of the report. Extra fields are not ignored. Look for message

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 *