Re: Owner of Table

From: chris <cwalz@mayn.de> > >hi, >yes their is a way. update systables! i did it and got no probs WARNING: This is unsupported. If you do it and something breaks, Tech Support will just laugh at you. >GP wrote: > > > I'd like to rename the owner part of a table. I had a table >"dba.tablename" > > that was being referenced by a bunch of reports. I ran a job as user > > "informix", which unloaded all the data, dropped the table and then > > recreated it and reloaded it. Obviously, the table's name is now > > "informix.tablename". > > The rename command does not affect the owner part of the table. > > Informix tells me that I can only rename the owner part of the table by > > performing the same process I performed above. > > Is there a quicker way to rename such table? > > Will making changes to the systables' owner column of that table cause > > damage? > > Thanks. > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.