RE: Routine myUDF in *LIBL not unique.

Why don't you qualify the function fully with the library (schema) name?  

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/db2/rbafzm
stdropst.htm

There is an example of DROP FUNCTION usage in that link.

If all fails, use iSeries Navigator:
* In the iSeries Navigator window, expand the system you want to use.
* Expand Databases.
* Expand the database and schema that you want to work with. Continue to
expand until the object that you want to drop is visible.
* Right-click the object you want to drop and select Delete, or press the
Delete key.
* On the Confirm object deletion dialog, confirm that these are the objects
that you wish to delete and click Delete.

This way you may be able to find other copies of your UDF as well.

Elvis



-----Original Message-----
Subject: Routine myUDF in *LIBL not unique.


I'm using the following SQL statement to delete an SQL UDF: "DROP FUNCTION
myUDF".
I get the following error message after the SQL statement executes:
"Routine myUDF in *LIBL not unique."

Does anyone know of a way to delete UDF's?

Thanks,

Frank