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"));