If a trigger exists on a primary table when that table is marked for replication, the existing trigger is modified to add a for-each-row section (if the trigger does not already contain a for-each-row section) to support Sybase replication.
The Sybase replication action in a trigger begins with a comment that serves as a marker so that, when the table is unmarked, the Sybase replication action can be removed from the trigger. If the resulting for-each-row section is empty, it will also be removed. If removing the for-each-row section leaves the trigger empty, the trigger will be dropped.
Do not remove or alter the Sybase replication comments
in triggers. If you need to modify a trigger that contains the Sybase
replication action, you must keep the Sybase replication action
at the end of the trigger (the last action in the trigger).
A “selective update” trigger is an update trigger that acts based on operations only in specified columns.
If a “selective update” trigger exists on a table, Replication Agent cannot modify the trigger and changes to that table cannot be replicated. For more information on the “selective trigger” limitation, see “Selective triggers”.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
