Value 

Meaning 

batAppend  

Append the records in the source to the destination table. The destination table must already exist, and the two tables must not have records with duplicate keys. This is the default mode.  

batUpdate  

Replace records in the destination table with matching records from the source table. The destination table must exist and must have an index defined to match records.  

batAppendUpdate  

If a matching record exists in the destination table, replace it. Otherwise, append records to the destination table. The destination table must exist and must have an index defined to match records.  

batCopy  

Create the destination table based on the structure of the source table. If the destination already exists, the operation will delete it, and replace it with the new copy of the source.  

batDelete  

Delete records in the destination table that match records in the source table. The destination table must already exist and must have an index defined.