Informix Error Messages and Error Codes From Error 9072 to 9142


Informix Error Code -9072; it can help you locate the record in error.
Informix Error Code -9071 A record in the flat ascii input file contains less 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. No default exists for missing fields. Look for message -9072; it can help you locate the record in error.

Informix Error Code -9072 count record(s) from the ascii input file have been read in.
This informational message helps you locate the source of a problem in the ASCII input file. The problem that is described in another message was found in the count line of the file.

Informix Error Code -9140 An attempt was made to divide by zero on line number. The result was set to zero.
An expression on line number of the report-specification file contains a division operation. At some point in the report run, the divisor in the expression was zero. Examine the expression and the data it uses and write the report so that division by zero will not occur (for example, by testing for zero in an IF statement). This error can result from applying an aggregate function to a defined variable before the first row of data is processed. To avoid this situation, make sure that any variable has a value before it is used (for example, by setting it from a command-line parameter or with a PROMPT FOR statement).
Informix Error Code -9142 Date conversion error.
ACEGO is trying to convert from characters into a DATE data type but found an error. Either the date is not punctuated correctly, unwanted nonnumeric characters are present, or the date itself is inconsistent (for example, “01/32/91”).

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 *