That is the default behavior. If an update gets zero rows affected, then it attempts an insert. That is called a "fallback" resolution. You can use the sym_conflict table to change the resolution behavior. For example, set the resolve_type to "manual" to receive an error when the update gets zero rows affected.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
If a row is not updated, then the dataloader will attempt to insert it.
How to close?
I do it this way.
insert into sym_conflict(resolve_row_only) values(1);
OK
That is the default behavior. If an update gets zero rows affected, then it attempts an insert. That is called a "fallback" resolution. You can use the sym_conflict table to change the resolution behavior. For example, set the resolve_type to "manual" to receive an error when the update gets zero rows affected.