create replication definition and alter replication definition allow you to control the application of dynamic SQL on each table through replication definition.
See the Replication Server Reference Manual for information about create/alter replication definition 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. You only need to use these commands to change the dynamic SQL usage if you want 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 related counters.
Use stored procedures rs_helprep, rs_helpsub, and rs_helppubsub to display dynamic SQL setting for each replication definition.
See “rs_helprep”, “rs_helpsub”, and “rs_helppubsub,” in Chapter 6, “RSSD Stored Procedures” in the Replication Server Reference Manual for information about using these stored procedures.
