17.10 - Error Tables - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.10
Release Date
June 2021
Content Type
Programming Reference
Publication ID
B035-2516-061K
Language
English (United States)

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