stage_operations

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.

Note: The stage_operations parameter can only be set for a connection to a Sybase IQ replicate (where the dsi_dataserver_make parameter is set to iq). The dsi_dataserver_make connection parameter is set appropriately when you use the Sybase IQ connection profile to create the connection.

dsi_compile_enable

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.