15.10 - DML Option - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

prodname
Parallel Transporter
vrm_release
15.10
category
Programming Reference
featnum
B035-2516-035K

DML Option

 

Table 5: 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.