Re: 314 - table in use error

In article <348CAF0C.52F7@informix.com>, June Tong <junet@informix.com> writes >aleggett@na.ko.com wrote: >> >> I found a posting related to a problem I am having. I'm running a .4gl >> script and doing a DROP. I receive the message 314 table in use. This >> table is not in use - I even brought the system up in maintenance (single >> user) mode to ensure this. >> >> I found a posting from Gennady (gena@oubaes.freenet.kiev.ua) with a great >> solution. Use SQL to run the following commands: >> >> DELETE FROM syscolumns where tabid = >> (select tabid from systables where tabname "mytable")>> >> DELETE FROM systables were tabname - "mytable"> >AAAAAAAAUUUUGGGGHHHHHH!!!!!!! DO NOT DO THIS! Did someone really >recommend this??? Just goes to show you get what you paid for on these >newsgroups... > Well I'm certainly not putting this in the FAQ!! >Assuming you are using OnLine, this will irretrievably (alright, maybe >it's reversible, but it'll be ugly) corrupt your instance. All sorts >of references to this table will still exist in your OnLine instance in >many other places, most of which you cannot access. You are just >asking for trouble if you do this. > Wonder what tbcheck -cre tbcheck -ccID <database name> would come up with? >What do you mean you brought the engine up in single-user mode? And I assume they mean Quiescent Mode. (Some people view this as similar to UNIX's single user (maintenance) mode. >what else (if anything) does your 4GL program do? > >June > >---- June Tong Informix Software ---- >---- Senior Consultant (650) 926-6140 ---- >---- International Support junet@informix.com ---- >---- Location-du-jour: Menlo Park ---- I do wish more people would listen to Informix and not try to poke around inside the engine. Viewing is ok, changing is not!! -- David Williams