DISABLE TRIGGERS statement
- Last Updated: November 9, 2026
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
Disables database triggers before you perform a dump or load procedure. You
must have CAN-DUMP and CAN-LOAD permissions on the table
for which you want to disable the triggers.
Syntax
|
- DUMP
- Disabling triggers for
DUMPdisables the trigger associated with theFINDevent for the named table. - LOAD
- Disabling triggers for
LOADdisables all triggers associated with theCREATE,WRITE,DELETE,REPLICATION-CREATE,REPLICATION-WRITE,REPLICATION-DELETE, andASSIGNevents for the named table. - table-name
- The name of the table for which you want to disable the triggers. You can name only one table.
- ALLOW-REPLICATION
- Tells
DISABLE TRIGGERSto disable onlyCREATE,ASSIGN, andWRITEtriggers, and notREPLICATION-CREATE,REPLICATION-DELETE, andREPLICATION-WRITEtriggers. TheDELETEtrigger is not disabled.For more information on database replication, see the reference entry for the RAW-TRANSFER statement, and Manage the OpenEdge Database.
Example
The following example lets you dump or load the contents of a database
table. The procedure uses the DISABLE TRIGGERS statement to disable the
appropriate triggers before each dump or load operation.
r-dstrig.p
|
Notes
- Triggers disabled with the
DISABLE TRIGGERSstatement remain disabled for the duration of the procedure in which you issued the statement and any subprocedures. - The OpenEdge Data Dictionary automatically disables the appropriate triggers during data dump and load operations.
- The Disable Delete Trigger (-
disabledeltrig) startup parameter disables theDELETEtrigger whenALLOW-REPLICATIONis on for theDISABLE TRIGGERSstatement or the DISABLE-LOAD-TRIGGERS( ) method. For more information about this parameter, see Startup Command and Parameter Reference.