Progress
Language Reference
DISABLE TRIGGERS Statement
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 DUMP disables the trigger associated with the FIND event for the named table.
LOAD
Disabling triggers for LOAD disables all triggers associated with the CREATE, WRITE, and ASSIGN events 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 TRIGGERS to disable only CREATE, DELETE, ASSIGN, and WRITE triggers, and not REPLICATION-CREATE, REPLICATION-DELETE, and REPLICATION-WRITE triggers.
For more information on database replication, see the reference entry for the RAW-TRANSFER Statement in this book, and the Progress Database Administration Guide and Reference.
EXAMPLEThe 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.
NOTES
- You also can disable database triggers from the Data Dictionary.
- Triggers disabled with the DISABLE TRIGGERS statement remain disabled for the duration of the procedure in which you issued the statement and any subprocedures.
- The Progress Data Dictionary automatically disables the appropriate triggers during data dump and load operations.
SEE ALSO
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |