<No Subject Supplied>

Dave wrote >We will be releasing IQ with our product soon. We have >ran into a problem in that IQ needs informix table ownerships >to be the same as what has been defined in the data dictionary. >The problem is table ownerships are not consistent among >our established customers. >Is there anyway to set ownerships other than an unload >and load of the tables? >thanks, >dave >dheisler@bassinc.com Yes there is, although I think you might find it is frowned upon. Run the following command to get a list of tables with the owner column name in them: set isolation to dirty read; -- Online set lock mode to wait; select s.tabname from systables s, syscolumns c where s.tabid = c.tabid and c.colname = "owner" and s.tabname matches "sys*" This will give you a list of all the system tables that contain owner information. I usually write this to a file and edit the file as follows (you could use it as a sub-query for an update). update <tabname> set owner = "xyz" where owner <> "informix"; In standard engine you may need to check the ownerships of the .dat/.idx files. I have used this method to bring ownerships into line on our systems and they are still working fine, you may need to be careful if you run any thrid party products that add their own tables to your databases though. Mark Denham BBC London, UK Mark.Denham@bbc.co.uk