truncate table

Posted in 2012

CHUAN LU — Wed, 18 Jul 2012 23:40:12 — source: IIUG Forums & Mailing Lists

HI, In the single transaction I found truncate table can't used with other update/delete sql together, How to implement it? the performance of delete all the rows are too slow. thanks for your time.

↪ replying to CHUAN LU

Fernando Nunes — Thu, 19 Jul 2012 10:21:44 — source: IIUG Forums & Mailing Lists

You need to close the transaction where you truncate the table.... That's a limitation, but a minor one if you compare to other RDBMS where you cannot rollback DDLs. After truncate you cannot make more operations on the same table on the same table before closing the transaction. On Jul 19, 2012 12:40 AM, "CHUAN LU" <luchuan@cn.ibm.com> wrote: > HI, > > In the single transaction I found truncate table can't used with other > update/delete sql together, How to implement it? the performance of delete > all > the rows are too slow. > > thanks for your time. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf30334ebb32cc7504c52c256b