RE: Drop SQL function with unknown parameters

Thanks, Luis.

We lowly contractors have only "basic operations" options under each of the
systems to which we have access. (No Database, et cetera.) Unfortunately
this does not fall in the basic operations category. I'll try to remember
this for the next client, though. :)

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"It is only impossible until it is not."
-- Captain Jean-Luc Picard

Go to iSeries Nav, Data Base, Schemas, Select your lib and find your
function there. Right click and delete.

Regards,

Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries


On Wed, May 26, 2010 at 2:46 PM, Dennis Lovelady
<iseries@xxxxxxxxxxxx>wrote:

We need to drop an SQL UDF from the database. When we select from
SYSFUNCS,
this function appears only one time. When we do "DROP FUNCTION
<functionname>" the system returns SQL0476 ("Routine <functionname>

not

unique."). We don't know what parameters were used to create the

function

-
it was created before the dawn of history in this client's

perspective -

and
don't know how to parse the SPECIFIC_PARAMETERS column - nor do we
understand why that would be necessary since there appears to be no
overloading.



What options do we have if we really want to get rid of this UDF?



Dennis E. Lovelady
AIM/Skype: delovelady MSN: fastcounter@xxxxxxxxxxxx
<http://www.linkedin.com/in/dennislovelady>
www.linkedin.com/in/dennislovelady --
Tried to play my shoehorn... all I got was footnotes!



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.