The Stream driver uses a single error table that contains records rejected because of data conversion, constraint, or other errors. The APPLY statement for a load operation provides DML attributes and error option attributes that tell the Stream driver what it should do with errors. These attributes define a label and error treatment options for one or more immediately following INSERT, UPDATE, or DELETE statements. These options allow you to mark or ignore error conditions, such as duplicate rows and missing rows, etc. Marked error conditions can be directed to the error table.
These MARK/IGNORE options are:
- DUPLICATE INSERT ROWS
- DUPLICATE UPDATE ROWS
- MISSING UPDATE ROWS
- MISSING DELETE ROWS