Clear dependencies

If you create a UDX and declare dependencies for it, you can remove the dependencies by using the NO DEPENDENCIES option of the ALTER FUNCTION|AGGREGATE|LIBRARY commands or the CREATE [OR REPLACE] FUNCTION|AGGREGATE|LIBRARY commands. The NO DEPENDENCIES option is the default for these commands. It indicates that the UDX does not have any dependencies, and if the UDX object exists, it clears any previous dependencies for the object.

For example, to clear the dependencies for the sample UDF myfunc:

MYDB.SCHEMA(MYUSER)=> CREATE OR REPLACE FUNCTION myfunc(int)
RETURNS int4 LANGUAGE CPP PARAMETER STYLE NPSGENERIC 
EXTERNAL CLASS NAME 'CMyFunc' NO DEPENDENCIES 
EXTERNAL HOST OBJECT '/home/nz/udx_files/myfunc.o_x86' 
EXTERNAL SPU OBJECT '/home/nz/udx_files/myfunc.o_spu';