Informix Error -23759: None of the DATAFILES strings name valid data files.
Cause and resolution
None of the DATAFILES strings name valid data files.
An error occurred when the database server tried to expand the DATAFILES entries in an INSERT or SELECT statement for an external table. No valid filenames were found in the DATAFILES entries.
Examine the external tables entry, drop the external table, and reissue a corrected CREATE EXTERNAL TABLE statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23759 fires when none of an external table's DATAFILES entries resolve to a valid
filename — per the official guidance.
- Every
DATAFILESentry failing to name a valid file, per the official guidance — the direct, only cause.
Solutions / Resolution
- Examine the entries, drop the external table, and reissue a corrected
CREATE EXTERNAL TABLEstatement, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond every DATAFILES entry being
invalid.
Diagnostic Checks
- Check every
DATAFILESentry's format and target file, and correct them.
Related Errors / Related Topics
- -23742 — "CREATE EXTERNAL TABLE: Invalid DATAFILES entry." The single-entry version of this validity check.
None of the external table's DATAFILES entries named a valid file — correct them and
reissue.