How to view a Trigger Definition in AS400

ibm-midrange db2-400
Xombeh picture Xombeh · Oct 8, 2014 · Viewed 9.7k times · Source

I have been trying to view the Trigger Definition for a trigger for AS400, and can't seem to find the command to help me do it. I can list the triggers out, create or remove them, but how do I view the trigger definition.

Answer

David G picture David G · Oct 8, 2014

DSPFD FILE(LIB/FILE) TYPE(*TRG) will get you the basic information on what program is invoked and when a trigger fires.

Related questions

GETDATE() method for DB2

I have been trying for a while now to get a similar method to GETDATE() in DB2 for i. So far I have found the following: current date current timestamp current time Would it be possible for me to: select …

Read More
How do I programmatically run a complex query on an as400?

I'm new at working on an as400 and I have a query the joins across 4 tables. The query itself is fine, it runs in STRSQL and displays the results. What I am in struggling with is getting the query to …

Read More
Add a column to a DB2/400 table with a specific ordinal position

Is there an SQL command on the AS400/iSeries/System-i/whatever to add a column to a table in a specific ordinal position, or moving an existing column to a different position?

Read More