Re: Change ownership of tables?

On 25 Jul 2005 09:03:22 -0700, Chris S <cjsommer@gmail.com> wrote: > Hacking system tables can be fun, but I wouldn't suggest trying on a > production system. The "rename table" statement only works in XPS, not > in IDS. Been there, tried that... RENAME TABLE is supposed to work on IDS - can you justify your assertion? Or do you mean 'RENAME TABLE cannot be used to change owner in IDS whereas it can in XPS'? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/ sending to informix-list

Since the thread was about changing table ownership, that was the context of my statement. I had been following the thread all along so it didn't really occur to me to better state what I said. What I really meant was that 'rename table' cannot be used to change ownership of a table in IDS. Thanks for pointing that out to me. -- Chris