- DISCARD: ignore the offending SQL and continue with the next one
- FORCE: ignore the conflict, leave the SQL applied and continue with the next one (this differs from DISCARD only if the SQL actually changes something, i.e. the conflict is "too many rows updated/deleted")
- OVERWRITE: do not check old values, try again with just primary key in the where clause (thus this will fail if there is no row at all on apply with the PK value)
- NEWER,OLDER: look into target table (by primary key) and get values of specified columns (usually dates or number sequence). If the source row is newer/older, the operation becomes OVERWRITE, otherwise DISCARD.
- PLSQL: call user-specied PL/SQL function. The function must have prototype:
...
| Note |
|---|
Note: all the configured conflict handlers are listed in table: DBRSAPPLY_CONFLICT_HANDLERS. This has the same result running the command: dbvrep> SHOW_CONFLICT_HANDLERS |
See the Command Reference or use HELP SET_CONFLICT_HANDLERS for the exact syntax.