Trigger event on a replicated table.

Posted in 2007

Topics: High Availability & Replication, Triggers, Constraints & Referential Integrity, Platform-Specific Issues, Versions, Editions & End-of-Life

Zapata Martinez Alfonso — Wed, 21 Nov 2007 02:23:38 — source: IIUG Forums & Mailing Lists

Hi Gurús, I'm having a problem with a table than is bi-directional replicated. I defined a trigger on the central table to handle de insert event on it from another location, however when a record is inserted by de CDR server, it is not detected by the trigger which must write the record in another table. Is there any instruction to force the event or what i missed up. HP-UX 11i IDS 9.40.FC9 Thanks in advance. Alfonso.

↪ replying to Zapata Martinez Alfonso

Madison Pruet — Wed, 21 Nov 2007 02:34:55 — source: IIUG Forums & Mailing Lists

By default, we do not fire triggers on a replicated row. If you want t= o fire a trigger, you need to include the '-t' option on the 'define repl= ' = "Zapata Martinez = Alfonso" = <azapat@ref.pemex = To .com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect Trigger event on a replicated = table. [10423] = 11/20/2007 08:23 = PM = = = Please respond to = ids@iiug.org = = = Hi Gur=FAs, I'm having a problem with a table than is bi-directional replicated. I defined a trigger on the central table to handle de insert event on it from ano= ther location, however when a record is inserted by de CDR server, it is not= detected by the trigger which must write the record in another table. Is there any instruction to force the event or what i missed up. HP-UX 11i IDS 9.40.FC9 Thanks in advance. Alfonso. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Glossary

Enterprise Replication (ER/CDR)