Very large data types

Informix® uses the TEXT and BYTE data types to store very large texts or images. ORACLE 8 provides CLOB, BLOB, and BFILE data types. Columns of these types store a kind of pointer ( lob locator ). This technique allows you to use more than one CLOB / BLOB / BFILE column per a table.

Solution

The ORACLE database interface can convert BDL TEXT data to CLOB and BYTE data to BLOB.

Genero TEXT/BYTE program variables have a limit of 2 gigabytes, make sure that the large object data does not exceed this limit.

ORACLE BFILEs are not supported.