16.10 - MLoadDiscardDupRowUPI - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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.