Owner of Table

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.

hi, yes their is a way. update systables! i did it and got no probs chris 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.