15.10 - Using DELETE in Import Tasks - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

Parallel Transporter
Programming Reference

Using DELETE in Import Tasks

DELETE is a Teradata SQL statement that removes rows from a table or view that was previously identified as a target table through the use of the TD_TARGET_TABLE attribute.

The rules for using the DELETE statement in an Update import tasks are:

  • Apply the DELETE statements to either a table or a view, provided that the view does not specify a join
  • The number of input data records is unlimited
  • The equality values must be specified for all the primary index columns in the WHERE clause of a DELETE statement. Greater than and Less than operators cannot be used to specify a range of rows.
  • Do not use the OR construct in the WHERE clause of a DELETE statement. Instead, use two separate DELETE statements.
  • The procedure for using the DELETE statement in an Update import task is:

    1 Add a DELETE statement to a DML group

    2 Add the DML group to the Connection object

    3 initiate the Connection object

    4 Set the DML group containing the DELETE statement using the UseDMLGroups function

    Note: If the DML group only contains a DELETE statement, then no data will be loaded as a result of the PutRow function call.

    5 Make at least one call to the PutRow function

    6 Call the ApplyRows function

    7 Terminate the Connection object

    Note: If no row in the target table matches the DELETE statement, then the row of data sent with the DELETE statement will be put into the application error table.