16.10 - DML Option Categories - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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.