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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

verify_threshold option [SQL Remote]

Controls which columns are verified when updates are replicated.

Allowed values

Integer, in bytes



  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY USER DEFINED OPTION Yes Yes, with SET ANY USER DEFINED OPTION
Allowed to set temporarily? No No No

This option is used by SQL Remote only. If the data type of a column is longer than the threshold, old values for the column are not verified when an UPDATE is replicated. This keeps the size of SQL Remote messages down, but has the disadvantage that conflicting updates of long values are not detected.