17.10 - MLoadDiscardDupRowUPI - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
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

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 Information

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