Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
william.downie — — source: Informix-list mailing list archive (1991-1998)
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
↪ replying to william.downie
Kevyn Schneider — — source: Informix-list mailing list archive (1991-1998)
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
>
>
>
>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.