Using Delete Task - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities

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:

  • Only one special session can be connected
  • Only one instance may be specified
  • Only one DML group may be specified
  • Only one DML statement in the DML group may be specified
  • Only one target table may be specified
  • The first error table is not used and is ignored
  • Only one data record is provided if using variable substitution in the WHERE clause.
  • There can be no calls to the EndAcquisition function.
  • 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