how to use BLOB/CLOB in Trafodion?

[Liu, Ming (Ming)]

Hi, all,

I am interested about how can a user use BLOB/CLOB in Trafodion?
I see usage of stringtolob() and lobtostring() like this:

insert into tbl values(1,stringtolob('clob values'));
select lobtostring(c2,10) from tbl;

This is fine if I have not too long string, but if I have a big text file and 
want to insert the whole text file into a CLOB column, how can I do that?

Thanks,
Ming