Re: Deleting all rows from standard (with loggin) table on IDS 9.40

Lukas Quickest and cleanest way is to drop and recreate the table. Keith On 21/09/06, Lukas Barton <lukas@cnawr.cz> wrote: > Hi, > > how can I delete all rows from standard (with loggin) table on IDS 9.40? > - on tuncate table [table_name] server report synstax error (SQL > State: 42000, Error Code: -201) > - on delete from [table_name] causes long transaction error (SQL > State: IX000, Error Code: -458) > > I use JDBC. > There are about 300 000 rows in table. > Locking mode is page. > Database is non-ansi. > Table have some foreing keys and indexes. > > Thanks helping me, > > Lukas > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >