17.00 - DML Option - 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
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.