Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Remote » SQL Remote Replication Design » SQL Remote replication design and set up » Update conflicts » Custom conflict resolution using a VERIFY clause

 

UPDATE statements with a VERIFY clause

An UPDATE statement with a VERIFY clause takes the following form:

UPDATE table-list 
SET column-name = expression, ... 
[ VERIFY (column-name, ...)
   VALUES ( expression, ...) ] 
[ WHERE search-condition ]
[ ORDER BY expression [ ASC | DESC ], ... ]

The VERIFY clause can be used only when the table-list parameter consists of a single table. It compares the values of specified columns to a set of expected values, which are the values that were present in the publisher database when the UPDATE statement was applied. When the VERIFY clause is specified, only one table can be updated at a time.

The VERIFY clause is useful only for single-row updates. However, a multi-row UPDATE statement executed on a database is replicated as a set of single-row UPDATE statements by the SQL Remote, so this imposes no constraints on client applications.

See also