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.
David I. Berg — — source: Informix-list mailing list archive (1991-1998)
scheer@stadt-mh.de (Dirch Scheer) writes:
>Via ISQL or R4GL we have tried the following SQL-Statement
> select count(*) from eworte
> where e_asyl > 0
> and e_ord_stamm in
> ( select s_ord from ewstamm
> where s_staat_1 > 0
> and s_hwnw < 3
> )
> into temp tmp_eworte
>This statement ends with the error message -458 (Long transaction aborted).
>Why do we get this message???? There are no rows updated or inserted by the
>statement and there is no BEGIN WORK given before. Can anybody explain this
>to me????
The logical logs are being filled with inserts into the temp table. (Please
don't flame the messenger; the default is that temp table activity is logged.)
You should change the INTO TEMP clause to read:
INTO TEMP tmp_eworte WITH NO LOG;
^^^^^^^^^^^
___ ___ Senior Consultant
/ ) __ . __/ /_ ) _ _ __ Informix Software Inc. (303) 850-0210
_/__/ (_(_ (/ / (_(_ _/__) (-' ~/ '(_- 5299 DTC Blvd #740 Englewood CO 80111
>+----------------------------------------------------------------------------+
>| Dirch Scheer email: scheer@stadt-mh.de |
>| Amt 10-3 Tel. : +49 208 455 1006 |
>| Stadtverwaltung (snail-)Mail : Ruhrstr. 32 |
>| Muelheim an der Ruhr D-45468 Muelheim an der Ruhr |
>|----------------------------------------------------------------------------|
>| Inspiration gave them the motivation to move on out their isolation |
>+----------------------------------------------------------------------------+
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.