rs_triggers

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.

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.