Informix Error -23742: CREATE EXTERNAL TABLE: Invalid DATAFILES entry.
Cause and resolution
CREATE EXTERNAL TABLE: Invalid DATAFILES entry.
A DATAFILES entry does not have the correct format. The format for an entry is filetype:coserver-info:rooted-path-name.
Check that the file type is a valid type (DISK or PIPE), that the second item names a cogroup or a coserver number, and that the last item names a file that can be accessed by the coserver that manages it.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23742 fires when a DATAFILES entry doesn't follow the correct
filetype:coserver-info:rooted-path-name format — per the official guidance.
- An invalid file type (not
DISKorPIPE), per the official guidance — the first named case. - An invalid cogroup/coserver number in the second field, per the official guidance — the second named case.
- A file path the managing coserver can't access, per the official guidance — the third named case.
Solutions / Resolution
- Check that the file type is
DISKorPIPE, per the official guidance. - Check that the second item names a valid cogroup or coserver number, per the official guidance.
- Check that the last item names a file accessible by the managing coserver, per the official guidance.
Examples
A correctly formatted DATAFILES entry
DATAFILES ("DISK:1:/data/orders.unl")
Diagnostic Checks
- Check the
DATAFILESentry's three fields (type, coserver info, path) against the required format.
Related Errors / Related Topics
- -23743 — "CREATE EXTERNAL TABLE: Missing DATAFILE entries." A related
DATAFILES-configuration error, on the entry being absent entirely rather than malformed.
A DATAFILES entry didn't follow the required filetype:coserver-info:rooted-path-name
format — check all three fields.