Oninit
Talk to an expert →

Informix Error -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.

Cause and resolution

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 -9072; it can help you locate the record in error.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9070 fires when a record in the flat ASCII input file has more delimiter-separated fields than the report's DEFINE ASCII statement declares — per the official guidance.

  1. A record with more delimiter characters (fields) than declared in DEFINE ASCII, per the official guidance — the direct, only cause; extra fields are not ignored.
Solutions / Resolution
  1. Check the ASCII file's field structure against the report's DEFINE ASCII statement, per the official guidance.
  2. Use the accompanying -9072 message to locate the record in error, per the official guidance.
Examples
An input record with an extra field
DEFINE ASCII name, address, city   -- three fields declared

"Jane Doe","123 Main St","Springfield","extra"   -- -9070: four fields present
Diagnostic Checks
  1. Check the -9072 record-count message to locate the offending line, and count its delimiter characters against the DEFINE ASCII field count.
Related Errors / Related Topics
  • -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." The inverse case — fewer fields than declared.
  • -9072 — "The count records from the ascii input file have been read in." The informational companion message that helps locate the offending record.

An input record had more fields than the report's DEFINE ASCII statement declares — check the record against the declared field count, using -9072 to locate it.