Re: dropping tmp tables...
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?
>
>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>