SQL Remote User's Guide
SQL Remote Design for Adaptive Server Enterprise
Managing conflicts
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:
The UPDATE is applied.
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.