DB2 TRUNCATE Clause
The equivalent of the SQL Server TRUNCATE clause for DB2 v8 is
ALTER TABLE {TABLE-NAME} ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE
The equivalent of the SQL Server TRUNCATE clause for DB2 v8 is
ALTER TABLE {TABLE-NAME} ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE