duplicates_clause
Syntax
<duplicates_clause> ::= IGNORE DUPLICATES | REJECT DUPLICATES | UPDATE DUPLICATES
|
IGNORE DUPLICATES |
The new line is not inserted. |
|
REJECT DUPLICATES |
The new line is rejected with an error message. |
|
UPDATE DUPLICATES |
The new line overwrites the existing line. |
Use
Use this
syntax rule for table descriptions in a DATALOAD command to specify how to proceed when loading data from a source file, and a line with the same key as the new line already exists in the target file.If you do not specify anything,
REJECT DUPLICATES is the default.
DATALOAD TABLE customer
UPDATE DUPLICATES
cno 01-04
surname 06-12
zip 14-18
city 20-31
INFILE 'customer.data' FORMATTED