generateGrantStatements

Generates a set of generic GRANT statements for the built-in Java UDRs.

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 |