Triggers

Component Integration Services allows triggers on proxy tables; however, their usefulness is limited. You can create a trigger on a proxy table and the trigger is invoked just as it would be for a normal Adaptive Server table. However, before and after image data is not written to the log for proxy tables because the insert, update, and delete commands are passed to the remote server. The inserted or deleted tables, which are actually views into the log, contain no data for proxy tables. Users cannot examine the rows being inserted, deleted, or updated, so a trigger with a proxy table has limited value.

In Adaptive Server version 15.0 and later, there is no support for the updated function with triggers.