Contents Index Managing conflicts Implementing conflict resolution

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Enterprise
    Managing conflicts

How SQL Remote handles conflicts


When a conflict is detected 

SQL Remote replication messages include UPDATE statements as a set of single row updates, each including the values prior to updating.

An UPDATE conflict is detected by the database server as a failure of the values to match the rows in the database.

Conflicts are detected and resolved by the Message Agent, but only at a consolidated database. When an UPDATE conflict is detected in a message from a remote database, the Message Agent causes the database server to take two actions:

  1. The UPDATE is applied.

  2. Any conflict resolution procedures are called.

UPDATE statements are applied even if the VERIFY clause values do not match, whether or not there is a resolve update procedure.

The method of conflict resolution is different at an Adaptive Server Anywhere consolidated database. For more information, see How SQL Remote handles conflicts.


Contents Index Managing conflicts Implementing conflict resolution