Informix Triggers

Please Help ! How can I see what triggers are attached to a table ? I have tried using dbschema, but it does not show what triggers are attached to the table ! Are there any good sites on how to program triggers, or any good books which you can download on informix triggers/procedures Thanks Will Downie

In article <7c0ejd$64u$1@nclient1-gui.server.virgin.net>, "william.downie" <william.downie@virgin.net> wrote: > Please Help ! > > How can I see what triggers are attached to a table ? > > I have tried using dbschema, but it does not show what triggers are attached > to the table ! > > Are there any good sites on how to program triggers, or any good books which > you can > download on informix triggers/procedures > > Thanks > > Will Downie > > William, on my system ( IDS 7.13, AIX 4.2.1 ) dbschema works fine: dbschema -d <db name> -t <table name> You can also use dbaccess: dbaccess <dbname> <CR> <T>able <I>nfo tri<G>gers ... Anyway, don't forget to specify the version of your Engine / S.O. HTH Michele -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Try "dbaccess dbname@servername"/Table/Info/"tablename"/triGgers for an easy, interactive way to look at your triggers. Checkout http://www.informix.com/answers for manuals. -Kevyn On Mon, 8 Mar 1999 12:08:39 -0000, "william.downie" <william.downie@virgin.net> wrote: >Please Help ! > >How can I see what triggers are attached to a table ? > >I have tried using dbschema, but it does not show what triggers are attached >to the table ! > >Are there any good sites on how to program triggers, or any good books which >you can >download on informix triggers/procedures > >Thanks > >Will Downie > > > >