Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Mike South — — 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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.