RE: DDL scripts?

["Richard Casey" <casey_r@xxxxxxxxxxxxxxxx>]

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


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Pete Hall
Sent: Tuesday, May 24, 2005 2:57 PM
To: midrange-l@xxxxxxxxxxxx
Subject: DDL scripts?


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/