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.