Oninit
Talk to an expert →

Informix Error -26175: DATAFILES entry are missing.

Cause and resolution

DATAFILES entry are missing.

The DATAFILES entry in the CREATE EXTERNAL TABLE statement is missing. Add a DATAFILES entry and reissue the statement.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-26175 fires when CREATE EXTERNAL TABLE has no DATAFILES entry — per the official guidance.

  1. No DATAFILES entry given, per the official guidance — the direct, only cause; required.
Solutions / Resolution
  1. Add a DATAFILES entry and reissue the statement, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond a missing DATAFILES clause.

Diagnostic Checks
  1. Check CREATE EXTERNAL TABLE's USING clause for a DATAFILES entry, and add one if absent.
Related Errors / Related Topics
  • -26174 — "Incorrect DATAFILES entry." A related DATAFILES-clause error, on incorrect formatting rather than the clause being entirely absent.

CREATE EXTERNAL TABLE had no DATAFILES entry — add one.