DML Option Categories - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

DML Option Categories

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.