Purpose
Determines whether the DBS MultiLoad protocol will silently discard rows with UPI violations, or log these rows to the MultiLoad application error table.
Field Group
General
Valid Settings
| Setting | Effect |
|---|---|
| TRUE | MultiLoad silently discards rows with UPI violations, and does not log these rows to the application error table. |
| FALSE | MultiLoad logs rows with UPI violations to the application error table. |
Default
FALSE
Changes Take Effect
After the DBS Control record has been written.
Usage Notes
This setting is effective only when IGNORE DUPLICATE ROWS is specified for the MultiLoad DML LABEL command.
The MultiLoad application error table normally receives information about errors detected during the application phase of the MultiLoad import or delete task. It provides information about:
- Uniqueness violations
- Field overflow on columns other than primary index fields
- Constraint errors.
Related Topics
For more information about Teradata MultiLoad, see Teradata® MultiLoad Reference, B035-2409.