Contents Index EXTENDED_JOIN_SYNTAX option [database] FIRST_DAY_OF_WEEK option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

FIRE_TRIGGERS option [compatibility]


Function 

Controls whether triggers are fired in the database.

Allowed values 

ON, OFF

Default 

ON

Description 

When set to ON, triggers are fired. When set to OFF, no triggers are fired, including referential integrity triggers (such as cascading updates and deletes). Only a user with DBA authority can set this option. The option is overridden by the -gf command-line option, which turns off all trigger firing regardless of the FIRE_TRIGGERS setting.

This option is relevant when replicating data from Adaptive Server Enterprise to Adaptive Server Anywhere because all actions from Adaptive Server Enterprise transaction logs are replicated to Adaptive Server Anywhere, including actions carried out by triggers.


Contents Index EXTENDED_JOIN_SYNTAX option [database] FIRST_DAY_OF_WEEK option [database]