TEXT and BYTE (LOB) types
Informix®
Informix provides the TEXT,
BYTE, CLOB and BLOB data types to store very
large texts or binary data.
Legacy Informix 4GL applications typically use the
TEXT and BYTE types.
Genero BDL does not support the Informix CLOB and BLOB types.
IBM® DB2®
IBM DB2 supports the
LONG VARCHAR/CLOB and BLOB/VARGRAPHIC/DBCLOB types for large
objects storage
Solution
The DB2 database interface can convert BDL
TEXT data to DB2 CLOB and
BYTE data to DB2 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.
The
TEXT and
BYTE types translation can be controlled with the following FGLPROFILE
entries:dbi.database.dsname.ifxemul.text = { true | false }
dbi.database.dsname.ifxemul.byte = { true | false }