At 09:22 PM 2/09/2004 +0000, you wrote:

>Hi All,
>
>How do I ALTER the declaration of a UDF? I'm not finding the ALTER
>EXTERNAL FUNCTION command in any of my references.

There isn't one.

>Do you have to
>DROP the UDF first and then DECLARE it agian?

Yes.

>Also, can you DROP or ALTER a UDF that has dependencies?

No.
What you can do is redeclare the UDF with a different <name> in the DECLARE
EXTERNAL FUNCTION <NAME> clause, alter the dependent SPs to use the new
name, and eventually drop the old declaration when nothing is left that
uses it.

./heLen