Emptying a Table

You can empty the contents of an existing DB2 table.

To empty a table:

1.         In the DB2 Web Query navigation tree, click Tables.

The Tables branch expands, listing the available DB2 tables.

2.         Select the table you want to empty.

A drop-down menu appears.

3.         From the drop-down menu, select Empty.

A confirmation message appears.

4.         Click OK to empty the table.

DB2 Web Query removes the contents of the table, and displays a confirmation message.