Oninit cdi / Archive
Talk to an expert →

trigger on multiple databases

Posted in 2008

Topics: Triggers, Constraints & Referential Integrity, Versions, Editions & End-of-Life

Gentian Hila — — source: Usenet: comp.databases.informix

I need to create a trigger that spans two databases (needs to compare two tables in two different databases). Is that possible on IDS 9.40? And if it is can you point me where I can learn more about triggers in multiple databases. I know how to create triggers inside a database and have done that before. Thank you, Genti

↪ replying to Gentian Hila
Ian Michael Gumby — — source: Usenet: comp.databases.informix

On Oct 15, 9:54 am, "Gentian Hila" <genti.t...@gmail.com> wrote: > I need to create a trigger that spans two databases (needs to compare > two tables in two different databases). > > Is that possible on IDS 9.40? > > And if it is can you point me where I can learn more about triggers in > multiple databases. I know how to create triggers inside a database > and have done that before. > > Thank you, > > Genti Yes its possible to put a trigger on a database that would call a stored procedure which can access a table in a different database. That doesn't mean its advisable, or recommended.

Glossary