toString

Returns the LVARCHAR characters from a CLOB. The CLOB must be 32,000 bytes or less in size.

Setup Syntax
CREATE FUNCTION toString(CLOB) RETURNS LVARCHAR EXTERNAL NAME 'com.informix.judrs.LargeObjects.toString(java.sql.Clob)' LANGUAGE JAVA;
GRANT EXECUTE ON FUNCTION toString(CLOB) TO PUBLIC;
Usage
> insert into test values("Hello ", toClob("world"));
> select a, tostring(b) from test;
                   a |         (expression) |
----------------------------------------
               Hello |                world |