generateDropFunctionStatements

Generates a set of DROP statements for the built-in Java UDRs

Setup Syntax

CREATE FUNCTION generateDropFunctionStatements() RETURNS LVARCHAR EXTERNAL NAME 'com.informix.judrs.JFoundation.generateDropFunctionStatements()' LANGUAGE JAVA;
GRANT EXECUTE ON FUNCTION generateDropFunctionStatements() TO PUBLIC;

Usage

> > execute function generateDropfunctionstatements();
        (expression) |
--------------------
-- com.informix.judrs.JFoundation
DROP FUNCTION generateCreateFunctionStatements()
DROP FUNCTION generateCreateFunctionStatements(LVARCHAR)
DROP FUNCTION generateGrantStatements()
DROP FUNCTION generateDropFunctionStatements()