aj wrote:
> DB2 LUW 8.2 FP14 Red Hat AS 2.1
>
> Can I use SYSPROC.ALTOBJ() to simply rename a table that has complex
> dependencies (RI, functions, triggers, etc...)?
>
> Seems like all the logic is in there to tear down all the dependencies,
> rename the table, then build the dependencies back up again - but
> I don't see how to do it..
You can have ALTOBJ() simply produce the script. Dump it to a text file,
muck with it any which way you want and then execute it.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html