Informix Error -26384: FORMAT (%s) is not supported with BLOB, CLOB, BYTE or TEXT types
Cause and resolution
FORMAT (%s) is not supported with BLOB, CLOB, BYTE or TEXT types
The FORMAT type specified is not supported with BLOB, CLOB, BYTE or TEXT types. Use DELIMITED FORMAT when specifying BLOB, CLOB, BYTE, TEXT data types. The following is an example when this error is returned:
CREATE EXTERNAL TABLE exttab (col1 INTEGER, col2 BLOB, col3 CLOB, col4 BYTE, col5 TEXT) USING ( DATAFILES ( "DISK:/tmp/ext_byte.dat.%r(1..2); CLOBDIR:/tmp/clobdir1.%r(1..2); BLOBDIR=/tmp/blobdir1.%r(1..2)" ), DELUXE, DELIMITER "%", recordend "\n", maxerrors 20, rejectfile "/tmp/ext_byte.log" FORMAT 'FIXED' );
To fix the problem in example above, please change the definition to use FORMAT type DELIMITED instead of type FIXED.
FORMAT cannot be INFORMIX or FIXED if the external table contains BLOB, CLOB, BYTE or TEXT columns.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26384 fires when a CREATE EXTERNAL TABLE with BLOB/CLOB/BYTE/TEXT columns uses
a FORMAT other than DELIMITED — per the official guidance.
FORMATisINFORMIX/FIXEDwhile the table hasBLOB/CLOB/BYTE/TEXTcolumns, per the official guidance — the direct, only cause.
Solutions / Resolution
- Use
FORMAT 'DELIMITED', per the official guidance, when the table hasBLOB/CLOB/BYTE/TEXTcolumns.
Examples
FIXED format with a BLOB column
CREATE EXTERNAL TABLE exttab (col1 INTEGER, col2 BLOB, col3 CLOB, col4 BYTE, col5 TEXT)
USING (
DATAFILES ("DISK:/tmp/ext_byte.dat.%r(1..2); CLOBDIR:/tmp/clobdir1.%r(1..2);
BLOBDIR=/tmp/blobdir1.%r(1..2)"),
DELUXE, DELIMITER "%", recordend "\n", maxerrors 20,
rejectfile "/tmp/ext_byte.log"
FORMAT 'FIXED'
);
-- -26384: FORMAT 'FIXED' isn't supported with BLOB/CLOB/BYTE/TEXT
Corrected
FORMAT 'DELIMITED'
Diagnostic Checks
- Check the table's
FORMATwhen it hasBLOB/CLOB/BYTE/TEXTcolumns, and change it toDELIMITED.
Related Errors / Related Topics
- -26383 — "DATAFILES string (%s) with file type PIPE is not supported with BLOB/CLOB
types" A related
BLOB/CLOB-column external-table restriction, onDATAFILESfile type rather thanFORMAT. - -26391 — "FORMAT (%s) is not supported with collection types." The same class of
FORMATrestriction, for collection types rather thanBLOB/CLOB/BYTE/TEXT.
An external table with BLOB/CLOB/BYTE/TEXT columns used an unsupported FORMAT —
use DELIMITED.