Building DELETE statements

Build DELETE statements to delete rows from a database table.

Procedure

  1. Click the Delete tab.
  2. Drag the table from which you want to delete rows from the repository tree to the canvas. You must have previously placed the table definitions in the IBM® InfoSphere® DataStage® repository. The easiest way to do this is to import the definitions directly from your relational database.
  3. You must choose an expression which defines the rows to be deleted. Choose a predicate from the Predicate list in the filter panel. Then use the expression editor to specify the actual filter (the fields displayed depend on the predicate you choose). For example, use the Comparison predicate to specify that a column should match a particular value, or the Between predicate to specify that a column falls within a particular range. The filter appears as a WHERE clause in the finished statement.
  4. Click the Add button in the filter panel. The filter that you specify appears in the filter expression panel and is added to the update statement that you are building.
  5. Click on the Sql tab to view the finished query.