rs_triggers_reset

Description

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

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.

See also