17.10 - MLoadDiscardDupRowUPI - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

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


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.



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 Information

For more information about Teradata MultiLoad, see Teradata® MultiLoad Reference, B035-2409.