Re: DDL scripts?

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/