When you delete data from tables using SQL DB2 in your programs, you should always use a condition in the DELETE statement, unless you want to delete all the rows from a table.

In the case above, I resorted to using DELETE FROM statements for each table, and suffered the performance penalty. What I would have preferred is the ability to run a SQL script to delete all the ...