Using the Update Operator to Delete Data - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
kyx1608578396289.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use the Update operator with the DeleteTask attribute to delete data from the database. The Update operator functions as either a standalone or a consumer operator, depending on whether or not data is required to complete the deletion.

Consider the following rules when using the DeleteTask feature:
  • The DeleteTask feature may not be used on a database view.
  • Only one special session will be connected.
  • Only one instance may be specified.
  • Only one DML group may be specified.
  • Only one DML DELETE statement in the DML group may be specified.
  • Only one target table may be specified.
  • The first of the error tables (the acquisition error table) is not used and is ignored.
  • Only one data record may be provided if using a WHERE clause. For example, you can send more than one row to the data stream (from the producer operator), but only the first one is used.

For more information on use of the DELETE task with a standalone Update operator, see Teradata® Parallel Transporter Reference, B035-2436.