DB2 TRUNCATE Clause

tech — tags: — rohand @ February 9, 2011 12:15 AM

The equivalent of the SQL Server TRUNCATE clause for DB2 v8 is

ALTER TABLE {TABLE-NAME} ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE

©2012 appytizers. All rights reserved.