Triggers

Component Integration Services allows triggers on proxy tables; however their usefulness is limited. It is possible to create a trigger on a proxy table and the trigger will be 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.