Table columns containing LOB data can be created using a Create Table SQL statement in the following manner.
CREATE TABLE FOO ( C01 INTEGER, C02 BLOB, C03 CLOB);
The CONVERT function of ODBC Driver for Teradata supports BLOB and CLOB data types.
CONVERT will map
"{fn CONVERT(value_exp, SQL_LONGVARBINARY)}" to "(value_exp (BLOB))"
and
"{fn CONVERT(value_exp, SQL_LONGVARCHAR)}" to "(value_exp(CLOB))".