Show TOC

rs_triggers_resetLocate this document in the navigation structure

Turns off triggers in Adaptive Server and Oracle.

Examples
Example 1

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'
Example 2

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;;'
Note

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.

Usage
  • 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.

  • Standby database connections always use the system-provided class <rs_default_function_class>, which cannot be modified. For any other database connection, you do not need to create a function string for the rs_triggers_reset function, unless:
    • 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.