Table-Level Dynamic SQL Control

create replication definition and alter replication definition allow you to control the application of dynamic SQL on each table through replication definitions.

See create replication definition and alter replication definition in Replication Server Reference Manual > Replication Server Commands.

You can change the dynamic SQL execution at the table level for a specific replicate database by using:

set dynamic_sql {on | off}
for replication definition with replicate at
data_server.database

At the replication definition level, the default is to use dynamic SQL. Change the default only to exclude tables from dynamic SQL. To check for dynamic SQL usage, turn on stats_sampling and run admin stats, dsi command and look for DSIEDsqlPrepared, DSIEDsqlExecuted, and other dynamic SQL counters.

Use rs_helprep, rs_helpsub, and rs_helppubsub to display dynamic SQL settings for each replication definition.

See Replication Server Reference Manual > RSSD Stored Procedures.