RE: DROP FUNCTION

["Morgan, Paul" <Paul.Morgan@xxxxxxxxxxx>]

You would need to know the types of your three parameters then use the:

DROP FUNCTION name (type, type, type)

format.  I'd think you could decode the types from the PARM_SIGNATURE field in SYSFUNCS.  Also if you have already dropped the two parameter function as you said then just:

DROP FUNCTION name

will drop the remaining three parameter version. 

Paul 

Principal Programmer Analyst
IS Supply Chain/Replenishment

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of sjl
Sent: Wednesday, December 01, 2010 10:49 AM
To: midrange-l@xxxxxxxxxxxx
Subject: DROP FUNCTION

All -

Sometime ago I created an SQL UDF twice, with different parameters.  When I 
query the SYSFUNCS table, I can see it registered twice with different 
signatures, once with 2 parameters and again with 3 parameters.

I wanted to DROP /both/ functions, but I could not remember how I created 
the one that takes 3 parameters.

By using System i Navigator and expanding
Database->DbName->Schema->Libname->Functions,
I was able to right-click on each of the functions and deleted them.

Here is my question:
How would I use the green-screen SQL interpreter (STRSQL) to drop a UDF, not 
knowing how it was created?

Regards,
sjl