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..

Depending on what you what to rename - schema name vs. table name, - the SQL
statement RENAME maybe a much simpler approach.
http://publib.boulder.ibm.com/infoce...n/r0000980.htm

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany