The Delete operation lets you set a transaction to delete a specific row in a table or all the rows in a table. You must use the Where clause to select the rows to be deleted. If you do not use the Where clause, all the rows in a table are deleted. The Delete operation does not delete the table.
When you specify a Delete operation,
the Delete tab provides a read-only view
of the table.
You cannot assign any map variables to any of the rows in the table.
A transport map that uses a Delete operation will not have any output variables. Only the Input tab becomes available on the Transport Map window. When you add one or more input variables to the Input tab, they are used solely to build a Where clause. You can build a Where clause without input variables. For example, you can set a column to equal a constant.