<div>
how about just altering the function instead of dropping and creating it?
</div>


how about just altering the function instead of dropping and creating it?

<div>
Thanks! Sorry, i wrote it reverse..<br />
&nbsp; I have to modify the stored procedure which is called by many functions.<br />
&nbsp; Can we force drop the procedure after the change?
</div>


Thanks! Sorry, i wrote it reverse..
  I have to modify the stored procedure which is called by many functions.
  Can we force drop the procedure after the change?

<div>
i also said you should alter it... :-)
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
&nbsp; I'm on Db2 UDB 8.2<br />
&nbsp; I have a fucntion, which is calling a stored procedure inside it. <br />
&nbsp; I made changes to the function and tried to compile it, when it said, it cannot drop it as it has a dependency as the stored procedure. Soon i realized that there are a number of other functions that use this function and so, they all depend on this function. <br />
<br />
&nbsp; I'm not changing any of the dependencies. Can i force drop this function and re-create it without dropping all the dependencies?<br />
<br />
&nbsp; Please advise.
</div>
</div>


Hi,

  I'm on Db2 UDB 8.2
  I have a fucntion, which is calling a stored procedure inside it. 
  I made changes to the function and tried to compile it, when it said, it cannot drop it as it has a dependency as the stored procedure. Soon i realized that there are a number of other functions that use this function and so, they all depend on this function. 

  I'm not changing any of the dependencies. Can i force drop this function and re-create it without dropping all the dependencies?

  Please advise.

how to drop a procedure/function without dropping the dependencies

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.