Very large data types

Both Informix^® and IBM^® DB2^® provide special data types to store very large texts or images.

IBM DB2 supports the following large object types:

LONG VARCHAR / CLOB
BLOB / VARGRAPHIC / DBCLOB

Solution

The DB2 database interface can convert BDL TEXT data to CLOB and BYTE data to BLOB. Note that DB2 CLOB and BLOB columns are created with a size of 500K, while Genero TEXT/BYTE program variables have a limit of 2 gigabytes; make sure that the large object data does not exceed this limit.