You can use a Select with Delete operation to delete a row after it has been fetched from the table. The rows to be deleted in the table are based on the where clause associated with the transport map. The input map variables are used to specify values in a Where clause. The output map variables are used to return values from the column.
Using the Transport Map window, you can also specify an Order by clause. Order By determines the order in which rows will be returned by the database (either ascending or descending).
The following shows an example transport map with a Select with Delete operation that will select the data from the WIP_SCHEDULE table.
|
You will not see Select with Delete in the Actions list for the following database transport types because the specific databases do not support this SQL operation
|