Replication Server System Database Modifications

The rs_dbreps, rs_dbsubsets, and rs_objects system tables in the Replication Server System Database (RSSD) have been modified to support SQL statement replication.

System Table	Description
`rs_dbreps`	`status` column includes 4 new sets of 2-bit sets, each of which corresponds to a DML filter. The first bit of a set indicates if it is an empty filter and the second bit indicates if it is a negative statement set.
`rs_dbsubsets`	`type` column includes four new types: U, L, I, and, S corresponding to the DML UDIS filters. In this case, L is used for delete instead of D.
`rs_objects`	`attributes` column includes five new bits; one for each U, D, I, or S operation, and one to indicate if a table replication definition has fewer columns than the number of incoming data rows. A system function replication definition, rs_sqldml, also supports SQL statement replication.

System Table

Description

rs_dbreps

status column includes 4 new sets of 2-bit sets, each of which corresponds to a DML filter. The first bit of a set indicates if it is an empty filter and the second bit indicates if it is a negative statement set.

rs_dbsubsets

type column includes four new types: U, L, I, and, S corresponding to the DML UDIS filters. In this case, L is used for delete instead of D.

rs_objects

attributes column includes five new bits; one for each U, D, I, or S operation, and one to indicate if a table replication definition has fewer columns than the number of incoming data rows.

A system function replication definition, rs_sqldml, also supports SQL statement replication.