Chapter 5 Database Options
217
OFF
ON for Open Client and JDBC connections
When this options set to ON, you can use the @ sign instead of the colon as a
prefix for host variable names in Embedded SQL. This is implemented
primarily for Transact-SQL compatibility.
VERIFY_ALL_COLUMNS option
Controls whether messages that contain updates published by the local
database are sent with all column values included.
ON, OFF
OFF
This option is used by SQL Remote only. When it is set to ON, messages
that contain updates published by the local database are sent with all column
values included, and a conflict in any column triggers a RESOLVE
UPDATE trigger at the subscriber database.
VERIFY_THRESHOLD option
Controls which columns are verified when updates are replicated.
Integer, in bytes
1000
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.
WAIT_FOR_COMMIT option
Determines when foreign key integrity is checked, as data is manipulated.
ON or OFF
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
Default
Description
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
Function
Allowed values
Scope
To Next Page
Loading...