toClob
Converts any character field (char/varchar/lvarchar) into a CLOB.
Setup
Syntax
CREATE FUNCTION toClob(LVARCHAR) RETURNS CLOB EXTERNAL NAME 'com.informix.judrs.LargeObjects.toClob(java.lang.String)' LANGUAGE JAVA;
GRANT EXECUTE ON FUNCTION toClob(LVARCHAR) TO PUBLIC;
Usage
> create table test(a varchar(255), b clob);
> insert into test values("Hello ", toClob("world"));