In-Row LOB Column Replication

The semantics and interface for replicating in-row LOB columns in Adaptive Server 15.7 is the same as that of LOB columns in versions earlier than 15.7.

To mark in-row LOB columns for replication, use:

sp_setrepcol stored procedure: sp_setrepcol table_name [, {column_name | null} [, {do_not_replicate | always_replicate | replicate_if_changed}]] [, use_index] .

In addition, when replicating an in-row LOB column on the primary database, you can store the replicated data in-row or off-row, depending on the replicated database and replicated table settings. For example, if the page size is smaller in the replicate than in the primary, the replicated table row size is smaller, and the replicated LOB does not fit in-row; therefore the in-row value on the primary may be replicated as an off-row LOB value on the replicate.