DML Option - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide - 20.00
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-11-20
dita:mapPath
haz1691132518981.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ana1478611373864
lifecycle
latest
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.