Informix Error -23743: CREATE EXTERNAL TABLE: Missing DATAFILE entries.
Cause and resolution
CREATE EXTERNAL TABLE: Missing DATAFILE entries.
The DATAFILES entry in the CREATE EXTERNAL TABLE statement (or SELECT...INTO EXTERNAL statement) is missing. Add a DATAFILES entry and reissue the statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23743 fires when a CREATE EXTERNAL TABLE/SELECT...INTO EXTERNAL statement omits
the DATAFILES entry — per the official guidance.
- No
DATAFILESentry in the statement, per the official guidance — the direct, only cause.
Solutions / Resolution
- Add a
DATAFILESentry and reissue the statement, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a missing DATAFILES entry.
Diagnostic Checks
- Check the statement for a
DATAFILESclause, and add one if absent.
Related Errors / Related Topics
- -23742 — "CREATE EXTERNAL TABLE: Invalid DATAFILES entry." A related
DATAFILES-configuration error, on a malformed entry rather than a missing one.
A CREATE EXTERNAL TABLE statement was missing its DATAFILES entry — add one.