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