Turns off triggers in Adaptive Server and Oracle.
Creates an instance of an rs_triggers_reset function string for a user-created base function-string class for Adaptive Server.
create function string rs_triggers_reset for sqlserver2_function_class output language 'set triggers off'
Creates an instance of an rs_triggers_reset function string for a user-created base function-string class for Oracle.
create function string rs_triggers_reset for oracle_function_class output language 'BEGIN rs_trigger_control.enable();; END;;'
Unlike Adaptive Server, which has a set triggers off command, Oracle does not publish a session-level trigger control. Hence, you need to install the RS_TRIGGER_CONTROL package in the replicate Oracle database using create connection using profile to be able to work with rs_triggers_reset function string. See Replication Server Heterogeneous Guide > Oracle Replicate Data Server Issues.
By default, the rs_triggers_reset function is executed for the DSI connection to a standby database, and is not executed for any other DSI connection.
rs_triggers_reset has function-string-class scope.
During installation, Replication Server creates an initial rs_triggers_reset function string for the system-provided function-string classes.
The database connection uses a user-created base function-string class, and
You want to set the dsi_keep_triggers configuration parameter to “off” for the connection.
Create an rs_triggers_reset function string at the Replication Server that is the primary site for the class.
Setting dsi_keep_triggers to “off” for a database connection to execute rs_triggers_reset when the connection is established. The dsi_keep_triggers default is “off” for standby databases, and “on” for replicate databases. Use the alter connection or configure connection command to change this setting.