MLoadDiscardDupRowUPI - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantage™

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.