The replTrigDel.p procedure is used to delete the replication triggers. This procedure is run from the OpenEdge procedure editor connected to both the source database and the replication database (or to the source database with the embedded replication tables).

To delete replication triggers:
  1. Shut down all the database instances and PAS for OpenEdge instances prior to deleting the replication triggers.
  2. Navigate to the \db folder of Pro2 from the Windows Explorer, for example, C:\Pro2v61\db).
  3. Create a new folder named bprepl in the db folder.
  4. Navigate to the \bprepl folder in the Pro2 folder (C:\Pro2v61\bprepl) and copy the following folders:
    • repl_d
    • repl_w

    These folders contain the replication triggers and are required to process the replication queue records (also known as replq records).

  5. Paste the folders in the \db\bprepl folder of Pro2 (C:\Pro2v61\db\bprepl).
    Note: Ignore steps 4 and 5 if the triggers are already added in the \db\bprepl folder.
  6. Type prowin -db sports -db repl and click Enter.

    The Procedure Editor window appears.

  7. Open the ReplTrigDel.p file from C:\Pro2v61\utils in the Procedure Editor window.
  8. Enter the name of the source database (for example, sports), and close the Procedure Editor window.
  9. Restart all the database instances and the PAS for OpenEdge instance.
Note: Running the replTrigDel.p does not delete the trigger procedures. After the trigger definitions are removed, the trigger procedures do not execute even if they remain in the system.