In-Row LOB Column Replication

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

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

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.