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 Diagram Pane, select the table, view, user-defined function, synonym, or query, and then press DELETE, or right-click the object and then choose Remove in the resulting dialog box. You can ...