15.00 - MLoadDiscardDupRowUPI - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

MLoadDiscardDupRowUPI

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.