Set the stage_operations parameter of the create connection or alter connection command to have Replication Server write operations to staging tables for the specified connection.
You can configure staging for the replicate database connection. For example:
create connection to SYDNEY_IQ_RS.iq_db using profile rs_ase_to_iq;standard set username pubs2_maint set password pubs2_maint_pw set stage_operations to "on"
To selectively enable or disable staging for individual tables, use the stage_operations parameter of the alter connection command in reference to a specific replicate table. For example:
alter connection to SYDNEY_IQ_RS.iq_db for replicate table named lineitem_5 set stage_operations to "off"
Here, Replication Server will not stage operations for the lineitem_5 table but will instead replicate operations as normal.
If stage_operations is set to on, Replication Server ignores the setting of dsi_compile_enable and enables RTL for the connection. Operations are compiled, as when dsi_compile_enable is set to on, and then staged.