concat
Appends any character field (char/varchar/lvarchar) to a new CLOB object.
Setup
Syntax
CREATE FUNCTION concat(CLOB, LVARCHAR) RETURNS CLOB EXTERNAL NAME 'com.informix.judrs.LargeObjects.concat(java.sql.Clob,java.lang.String)' LANGUAGE JAVA;
GRANT EXECUTE ON FUNCTION concat(CLOB, LVARCHAR) TO PUBLIC;
Usage
> update test set clobCol = concat(clobCol, "more text") where id = 1;