Informix Error -26391: FORMAT (%s) is not supported with collection types.
Cause and resolution
FORMAT (%s) is not supported with collection types.
The FORMAT type specified is not supported with collection types. Use DELIMITED or FIXED FORMAT when specifying collection data types.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26391 fires when a CREATE EXTERNAL TABLE with collection-type columns uses an
unsupported FORMAT — per the official guidance.
FORMATisn'tDELIMITED/FIXEDwhile the table has collection columns, per the official guidance — the direct, only cause.
Solutions / Resolution
- Use
FORMAT 'DELIMITED'orFORMAT 'FIXED', per the official guidance, when the table has collection-type columns.
Examples
N/A
No specific triggering statement is documented beyond an unsupported FORMAT with a
collection column.
Diagnostic Checks
- Check the table's
FORMATwhen it has collection-type columns, and change it toDELIMITED/FIXED.
Related Errors / Related Topics
- -26384 — "FORMAT (%s) is not supported with BLOB, CLOB, BYTE or TEXT types" The
same class of
FORMATrestriction, forBLOB/CLOB/BYTE/TEXTrather than collection types — but note that cluster only permitsDELIMITED, one option narrower than this one.
An external table with collection-type columns used an unsupported FORMAT — use
DELIMITED or FIXED.