Select the Truncate table action to delete all the existing rows in the Orders table before the data load operation starts.
在数据加载操作开始之前，选择truncate表操作删除orders表中的所有已有行。
TRUNCATE table statement This statement quickly deletes the contents of an entire table without firing triggers.
TRUNCATE 表语句此语句无需激活触发器即可快速删除整个表的内容。
If a NOT LOGGED table encounters an execution error during a data changing statement there is only one choice for DB2: to truncate the table.
如果NOT LOGGED表在执行数据修改语句期间碰到了执行错误，那么对于DB 2来说，就只有一个选择：清空(truncate)该表。
Membership of a group that has sufficient authority to issue TRUNCATE TABLE statements and have CREATE TABLE statement privileges.
一组成员，拥有足够的授权来发出TRUNCATE table语句且拥有CREATE table语句权限。
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the truncate table operation fails.
此外，被truncate的表和其他表之间是不能有外键约束的，否则truncate TABLE操作会失败。
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the truncate table operation fails.
此外，被truncate的表和其他表之间是不能有外键约束的，否则truncate TABLE操作会失败。
应用推荐