17.00 - Error Tables - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

prodname
Parallel Transporter
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2516-220K

The Stream driver uses a single error table that contains records rejected because of data conversion, constraint, or other errors. The APPLY statement for a load operation provides DML attributes and error option attributes that tell the Stream driver what it should do with errors. These attributes define a label and error treatment options for one or more immediately following INSERT, UPDATE, or DELETE statements. These options allow you to mark or ignore error conditions, such as duplicate rows and missing rows, etc. Marked error conditions can be directed to the error table.

These MARK/IGNORE options are:

  • DUPLICATE INSERT ROWS
  • DUPLICATE UPDATE ROWS
  • MISSING UPDATE ROWS
  • MISSING DELETE ROWS