Re: Long transaction problem
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 |
>+----------------------------------------------------------------------------+