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 repl database (or to the source database with the embedded repl tables). Perform the following steps to delete replication triggers:
  1. Shut down all the database instances and PAS instance prior to deleting the replication triggers.
  2. Navigate to the \db folder of Pro2 from the Windows Explorer ( for example, C:\Pro2v60\db).
  3. Create a new folder named bprepl in the db folder.
  4. Navigate to the \bprepl folder in the Pro2 folder (C:\Pro2v60\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:\Pro2v60\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:\Pro2v60\utils in the Procedure Editor window.
  8. Enter the name of the source database (sports). Close the Procedure Editor window.
  9. Restart all the database instances and the PAS instance.
Note: Running the replTrigDel.p does not delete the trigger procedures. Once the trigger definitions are removed, the trigger procedures wont be executed even if they remain in the system.