Re: dropping tmp tables...

In article <6op1gk$k1q$1@tst.hk.super.net>, 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. > > -- > 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> > Sounds like a 7.1x DSA problem I've seen. Ensure that your create/drop table SQL does not cross transaction boundaries. Paul Watson WF Software Ltd. Tel. (+44) 1436 674729 Fax. (+44) 1436 678693