SEO

#1 (**permalink**) 02-27-2008, 11:30 AM

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

#2 (**permalink**) 02-27-2008, 11:30 AM

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

#3 (**permalink**) 02-27-2008, 11:31 AM

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

#4 (**permalink**) 02-27-2008, 11:31 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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