Re: dropping tmp tables...
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!!!!
>>Thanks.
>>
>>--
>>Chris Lo mailto: chris.lo@prudential.com.hk
>>System Administrator/Informix DBA mailto: cklo@cklo.hk.super.net
>>The Prudential Assurance (HK) Co. Ltd mailto: cklo@hk.super.net
>>===========================================================================
>===
>>-- Linux + FreeBSD + HPUX + Solaris + AIX
>>===========================================================================
>===
>>#include <std/disclaimer.h>
>
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care