Hi,

Here is an interesting question -- I have this scenario in my database :

Table A ( with a lot of functions and procedures associated with it)

Table B ( same structure as Table A)


Here is what will happen --

Table A will be renamed to Table C
Table B will be renamed to Table A

Then the original Table A ( now Table C) will be dropped.

The question is if with the whole renaming process, will the functions and stored procedures have to be recreated? Thanks!

I think the UDFs will need to be dropped before you do anything and recreated after you are done. The stored procedures should just have to have to be rebound. (see db2rbind to do them all at once).

Andy

thanks, i thought so too..

Why is this so? Is there a unique handle that DB2 uses for DB objects at compile time; therefore a renaming of a table will make no difference as the stored proc or UDF will always use that handle?

I will experiment and see if it works without recreating the functions / procedures..will let you know what I find..