Re: dropping tmp tables...

Posted in 1998

Mike South — Sat, 18 Jul 1998 08:13:26 GMT — source: Informix-list mailing list archive (1991-1998)

I don't have my manuals with me at the moment but 2 things come to mind. first is can you drop a table from within a transaction? second is if you can then would you want to? The transaction may need the tmp table to roll back (theoretically anyway) cklo@news.hk.super.net (Mr Cheuk Kong Lo) wrote: >Running AIX 4.1..5 and ODS 7.23UC4 here. We have (think) we found a bug >in tmp tables. A few of our programs will reuse tmp tables, so upon end >of usage, we just drop the tmp tble. But we got error -242. The workaround >we have is to use commit work, then drop. then it is ok. Has >anyone come across similar problem? > >Thanks. Mike South Producer/Director "Mike South's Peaches & Cream" "Mike South's Georgia Peaches" http://www.mike-south.com Winner 1997 AVN Best Amateur Video Winner 1998 AVN Best Amateur Video Winner 1996 Rocky Mountain Oyster Readers Poll Best Pro-Am Series