Using Delete Task
Use the Update driver’s Delete Task with or without variable substitution. If variable substitution is used, the Update driver requires a schema. The following sections give an overview of the steps needed to use the Update Delete Task.
Using DELETE in Delete Tasks
Deleting rows in a Delete Task is faster than deleting rows in an import task. The rules for using the DELETE statement in Delete tasks are:
The procedure for using the Update Delete Task without variable substitution is:
1 Set the TD_DELETE_TASK attribute to “Yes”
2 Add one DELETE statement to a DML group
3 Add the DML group to the Connection object
4 Initiate the Connection object
5 call the ApplyRows function
6 Terminate the Connection object
Note: Do not add a schema to the Connection object.
The procedure for using the Update Delete Task with variable substitution is:
1 Set the TD_DELETE_TASK attribute to “Yes”
2 Add the schema corresponding to the variable substitution to the Connection object.
3 Add one DELETE statement to a DML group
4 Add the DML group to the Connection object
5 Initiate the Connection object
6 Use PutRow to pass in variable substitution data (one call only)
7 call the ApplyRows function
8 Terminate the Connection object