Re: DDL scripts?

[Pete Hall <pbhall@xxxxxxxxxxxxx>]

Works great. Thanks Richard. I thought there must be an easy way to do that.


Richard Casey wrote:

> Pete,
>
> One way is to add
>
>         DROP FUNCTION myfunction;
>
> at the top of your DDL. Then when you use RUNSQLSTM, specify ERRLVL(31) so
> that your script won't abort if myfunction doesn't exist.
>
> Have fun!
> Richard
>
>
> I need to build a DDL script that deletes an object if it already
> exists. How can I do that without creating a HLL program? I've been
> using Implementer for database objects, but this is a little different,
> and I'm not finding much in the documentation. I'd like to run a script
> with RUNSQLSTM that drops the a UDF if it already exists, then runs my
> create function. Apparently this is an unusual need on
> eWhatever-it-is-this-week. Surely someone must be using scripts like this?
>
> --
>
> Pete Hall
> pbhall@xxxxxxxxxxxxx
> http://www.pbhall.us/
>
>
>