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

SAP Sybase SQL Anywhere 16.0 » SQL Remote » Creating SQL Remote systems » Update conflicts » Custom conflict resolution using a VERIFY clause

 

The verify_all_columns option

By default, the database option verify_all_columns is Off. When it is set to Off, only those columns that are updated are checked. When the verify_all_columns option is set to On, then:

  • All columns are verified on replicated UPDATE statements.

  • A RESOLVE UPDATE trigger is fired whenever any column is different.

  • The size of messages is bigger, because more information is sent for each UPDATE statement.

You can set the verify_all_columns option either for the PUBLIC role or just for the user contained in the SQL Remote connection string.

 The Extraction utility (dbxtract)
 See also