alter table/exclusive access

Posted in 2004

Bill Hamilton — Wed, 21 Jan 2004 13:35:23 -0600 — source: Usenet: comp.databases.informix

Sometimes I just need to add a new column to a table and would like to get it done in the daytime, but IDS wants the table exclusive. I've tried SET LOCK MODE TO WAIT; LOCK TABLE x IN EXLUSIVE MODE; ALTER TABLE ADD ........to no avail. Is there not anyway to get IDS to "alter" without blowing away users? sending to informix-list