Informix Error -23755: Missing delimiter at end of coserver item coserver-number, errno, filename.
Cause and resolution
Missing delimiter at end of coserver item coserver-number, errno, filename.
An error occurred when the database server tried to expand the DATAFILES entries in an INSERT or SELECT statement for an external table. The external table has a DATAFILES entry that does not have the expected colon separators between entries. The format for an entry is filetype:coserver-info:rooted-path-name.
Examine the external tables entry, drop the external table, and reissue a corrected CREATE EXTERNAL TABLE statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23755 fires when a DATAFILES entry is missing the expected colon separators — per
the official guidance, the required format is
filetype:coserver-info:rooted-path-name.
- A
DATAFILESentry missing a required colon separator, per the official guidance — the direct, only cause.
Solutions / Resolution
- Examine the entry, 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 a missing colon separator.
Diagnostic Checks
- Check the
DATAFILESentry's colon separators, matchingfiletype:coserver-info:rooted-path-name, and correct any missing one.
Related Errors / Related Topics
- -23742 — "CREATE EXTERNAL TABLE: Invalid DATAFILES entry." The general
DATAFILES-format error this is a specific missing-delimiter case of.
A DATAFILES entry was missing a colon separator — correct the entry and reissue.