viewing Trigger code

I am using triggers for the first time. I've created two triggers and have tested them successfully. Since they become part of the database I was wondering how to view the trigger code. For example, I can see the table definition with the 'dbschema' command. I can see the columns, indexes and other information with the 'info status for', 'info columns for', etc. Is there anything comparable for triggers? We have Online ver 7.24 Thanks Sent via Deja.com http://www.deja.com/ Before you buy.

A dbschema of the underlying table will output trigger information as well. Rudy jbcamel@mediaone.net wrote: > I am using triggers for the first time. I've created two triggers and > have tested them successfully. Since they become part of the database I > was wondering how to view the trigger code. For example, I can see the > table definition with the 'dbschema' command. I can see the columns, > indexes and other information with the 'info status for', 'info columns > for', etc. Is there anything comparable for triggers? > > We have Online ver 7.24 > > Thanks > > Sent via Deja.com http://www.deja.com/ > Before you buy.

jbcamel@mediaone.net wrote: > > I am using triggers for the first time. I've created two triggers and > have tested them successfully. Since they become part of the database I > was wondering how to view the trigger code. For example, I can see the > table definition with the 'dbschema' command. I can see the columns, > indexes and other information with the 'info status for', 'info columns > for', etc. Is there anything comparable for triggers? > > We have Online ver 7.24 > > Thanks > > Sent via Deja.com http://www.deja.com/ > Before you buy. SELECT tabname, trigname, event, old, new, datakey, seqno, data FROM systables st, systriggers tr, systrigbody tb WHERE st.tabname = "mytable" AND st.tabid = tr.tabid AND tr.trigid = tb.trigid AND tb.datakey in ("A","D") ORDER BY tabname, trigname, event, datakey DESC, seqno; Art S. Kagel