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.
WF Software — — source: Informix-list mailing list archive (1991-1998)
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
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.