Error Capture - 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

The APPLY statement that invokes the Stream operator provides DML error option attributes that tell the Update operator what to do with errors. These options allow you to mark or ignore error conditions, such as duplicate rows and missing rows. Marked error conditions are directed to the error table.

These MARK/IGNORE options are:

  • DUPLICATE ROWS (for both insert and update operations)
  • DUPLICATE INSERT ROWS (for insert operations)
  • DUPLICATE UPDATE ROWS (for update operations)
  • MISSING ROWS (both update and delete operations)
  • MISSING UPDATE ROWS (for update operations)
  • MISSING DELETE ROWS (for delete operations)

Specify these options in the APPLY statement, immediately following the DML statements to which they apply, to control error handling for those DML statements by the Update operator.

If neither option is specified in the APPLY statement, MARK is the default condition.

For more information, see “APPLY Statement” in the Teradata Parallel Transporter Reference (B035-2436).