![]() |
Publications
|
|
Publishing TriggersBy default, triggers are not published. This means they fire only on the source database, not on the target. If you want updates on the target to more closely follow the expected behavior at the source, you can publish a trigger. To do this, use the ADD TRIGGER clause of CREATE PUBLICATION, or the ADD TRIGGER or DROP TRIGGER clauses of ALTER PUBLICATION. If you try to publish a trigger that cannot function on a target because of a database object discrepancy (for example, it modifies an unpublished table), the CREATE PUBLICATION or ALTER PUBLICATION will not succeed. However, there are some scenarios in which the CREATE PUBLICATION statement for a trigger may succeed, but the trigger will still fail on the target. For example, as with any other class reference, your trigger may fail at the target if it references a class in the source classpath that isn't in the target's classpath. Please verify that triggers work at the target. If the published trigger operation is a Java method call, the target looks for a Java class with the given class name. In this scenario, verify the desired classes are available at the target before firing the trigger. See Triggers and the Refresh Operation for details on how changes caused by a trigger at the target are handled at the source. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |