Use SYSPROC.ALTOBJ() to simply rename a table?

[aj]

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

TIA

aj

[Serge Rielau]

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

[Knut Stolze]

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

[andyhe]

Maybe creating an alias for your table is an option? Leave the original
as it is and have a second object (alias, can be in another schema)
referring to the original.