Kbase P139909: What is the syntax to delete a trigger from a database using a df file?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/04/2010 |
|
Status: Verified
GOAL:
What is the syntax to delete a trigger from a database using a df file?
GOAL:
How to use an incremental Data Definition file (delta.df) to remove specific database events' triggers.
GOAL:
How to remove the Customer table CREATE and DELETE schema triggers in the sports2000 database?
FACT(s) (Environment):
OpenEdge 10.1B
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The following sample delta.df will remove ( delete ) the the Customer table CREATE and DELETE schema triggers from the sports2000 database:
UPDATE TABLE "Customer"
TABLE-TRIGGER "CREATE" DELETE
TABLE-TRIGGER "DELETE" DELETE
The above delta .df may be applied to the sports2000 programmatically by executing the following code snippet from a 4GL/ABL client connected to the database:
CREATE ALIAS DICTDB FOR DATABASE sports2000.
RUN prodict/load_df.p ("delta.df").
DELETE ALIAS DICTDB.
QUIT.
The above delta .df may be also applied against the sports2000 using the Data Administration by selecting the following options:
Admin | Load | Data Definitions (.df file)...| Delta.df | 'Stop If Errors Found' | OK