Deleting the contents of staging tables - IBM DB2 9.7 for Linux, UNIX, and Windows

You can delete the contents of a staging table.

Before you begin

To delete the contents of a staging table, you need the following authorities:

To delete the contents of a staging table using the Control Center:
1. Open the Set Integrity window: From the Control Center, expand the object tree until you find the Tables folder. Click on the Tables folder. Any existing tables are displayed in the pane on the right side of the window. Right-click the table you want and select Set Integrity from the pop-up menu. The Set Integrity window opens.
2. Review the Current integrity status of the table you are working with.
3. If the table is in Set Integrity Pending state, select the Immediate and checked and the Prune check box in the Options group box to delete the contents of the staging table and to propagate to the staging table.
4. If the table is not in Set Integrity Pending state, select the Prune radio button to delete the contents of the staging table without propagating to the staging table. If you select the Immediate and checked radio button, the table will be brought out of Set Integrity Pending state.
To delete the contents of a staging table using the command line, use the SET INTEGRITY statement.