Determining Trigger Mode

Posted in 2006

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

Ben — Thu, 23 Mar 2006 13:17:21 -0500 — source: Usenet: comp.databases.informix

Does anyone have an SQL statement that can be executed to determine the 'mode' of a trigger? I need to run a script that ensures that all triggers are set to 'enabled'. The systriggers table has a field named 'mode' but it is not an active field, the manual says it is reserved for future use... IDS 10.0 FC3 Solaris 10 Thanks in advance, Ben

↪ replying to Ben

SaltTan — 24 Mar 2006 01:13:43 -0800 — source: Usenet: comp.databases.informix

look at the table sysobjstate Ben wrote: > Does anyone have an SQL statement that can be executed to determine the > 'mode' of a trigger? I need to run a script that ensures that all triggers > are set to 'enabled'. The systriggers table has a field named 'mode' but it > is not an active field, the manual says it is reserved for future use... > > IDS 10.0 FC3 > Solaris 10 > > Thanks in advance, > > Ben