DML Option Categories - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

The DML Options can be classified into four logical categories, which can be specified in any order:

  • ARRAY SUPPORT
  • SERIALIZE
  • USE
  • DML ERROR OPTIONS, which include:
    • MARK
    • IGNORE
    • INSERT FOR

The following restrictions apply:

  • Multiple ARRAY SUPPORT Options cannot be specified.
  • Multiple SERIALIZE Options cannot be specified.
  • Multiple USE Options cannot be specified.
  • Multiple DML Error Options (MARK,IGNORE, INSERT FOR) can be specified in one block. However these cannot be interleaved with the other three DML Option categories.