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;