DML Option - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.00
Published
November 30, 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
fcz1544831938753.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities
DML Group Options 
Constant Description
IGNORE_DUPLICATE_ROWS Duplicate rows for both insert and update operations are ignored.
IGNORE_DUPLICATE_INSERT_ROWS Duplicate rows for insert operations are ignored.
IGNORE_DUPLICATE_UPDATE_ROWS Duplicate rows for update operations are ignored.
IGNORE_EXTRA_DELETE_ROWS Rows that effect more than one row in the target table for delete operations are ignored. This option is supported only by the Stream driver.
IGNORE_EXTRA_ROWS Rows that effect more than one row in the target table for delete or update operations are ignored. This option is supported only by the Stream driver.
IGNORE_EXTRA_UPDATE_ROWS Rows that effect more than one row in the target table for update operations are ignored. This option is supported only by the Stream driver.
IGNORE_MISSING_ROWS Missing rows for update and delete operations are ignored.
IGNORE_MISSING_DELETE_ROWS Missing rows for delete operations are ignored.
IGNORE_MISSING_UPDATE_ROWS Missing rows for update operations are ignored.
INSERT_FOR_MISSING_UPDATE_ROWS This option applies only when the DML group consists of a single update statement, followed by a single insert statement.
MARK_DUPLICATE_ROWS Duplicate rows for both insert and update operations are placed in error table. This is the default setting.
MARK_DUPLICATE_INSERT_ROWS Duplicate rows for insert operations are placed in error table. This is the default setting.
MARK_EXTRA_DELETE_ROWS Rows that effect more than one row in the target table for delete operations are placed in the error table. This is the default setting. This option is supported only by the Stream driver.
MARK_EXTRA_ROWS Rows that effect more than one row in the target table for delete or update operations are placed in the error table. This is the default setting. This option is supported only by the Stream driver.
MARK_EXTRA_UPDATE_ROWS Rows that effect more than one row in the target table for update operations are placed in the error table. This is the default setting. This option is supported only by the Stream driver.
MARK_MISSING_DELETE_ROWS Missing rows for delete operations are placed in error table. This is the default setting.
MARK_MISSING_ROWS Missing rows for update and delete operations are placed in error table. This is the default setting.
MARK_MISSING_UPDATE_ROWS Missing rows for update operations are placed in error table. This is the default setting.
MARK_MISSING_UPDATE_ROWS Missing rows for update operations are placed in error table. This is the default setting.