Re: Long transaction problem
David I. Berg (dberg@informix.com) wrote:
> 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 |
> >+----------------------------------------------------------------------------+
--
+----------------------------------------------------------------------------+
| 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 |
+----------------------------------------------------------------------------+