Re: dropping tmp tables...
David Williams wrote:
>
> In article <6p63mv$r9q$1@excalibur.flash.net>, joe vanderveen
> <tycnine@flash.net> writes
> >Are you creating the table like:
> >create temp table the_temp_table
> >(
> >the_field char(30)
> >) with no log in tempdbs;> >
> >if so, you should not have to drop the table, it should go away when the
> >process
> >that created it is done ....
> >
> >
> >Mr Cheuk Kong Lo wrote in message <6op1gk$k1q$1@tst.hk.super.net>...
> >>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?
> >>
>
> Yes, you have a cursor open on the table. The commit closes the cursor
> allowing you to drop the table..took me hours to spot!!!!
I think if you explicitely create the temp table and add the WITH NO
LOG clause this problem goes away.
Art S. Kagel