RE: DDL scripts?

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

What about having the same function in multiple libraries?  We have a system 
with different environments for testing purposes and a function has to reside 
in each environment.  It is registered for each library it is contained in.  
Using this method to drop will it drop the one in the library list?

Rick

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Pete Hall
Sent: Tuesday, May 24, 2005 2:52 PM
To: Midrange Systems Technical Discussion
Subject: 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

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.