Specifies that trigger actions should be sent on upload.

Syntax

st={ ON | OFF }; ...

Remarks

Cascaded deletes are also considered trigger actions.

The default is OFF.

This option has a short form and long form: you can use st or SendTriggers.

If two publications are overlapping, that is they both contain one or more of the same tables, then both publications must be synchronized with the same setting for the SendTriggers option.

You can also store extended options in the database. For more information about dbmlsync extended options, see Introduction to dbmlsync extended options.

Example

The following dbmlsync command line illustrates how you can set this option when you start dbmlsync:

dbmlsync -e "st=on"

The following SQL statement illustrates how you can store this option in the database:

CREATE SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication
   FOR ml_user1
   OPTION st='on';