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

A frequently used skill, Make the transaction smaller: control your delete activities in a script and frequently(based on number of rows, or some conditions, ...) commit the transaction. Frank Keith Simmons wrote: >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 >> >> >> >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list > > > -- Yunyao "Frank" Qu Computer Sciences Corporation(CSC) NOAA/CLASS, (301)817-4696