Well you can use DSPFD but how about just query the view SYSTRIGGER
SELECT SUBSTR(TABSCHEMA,1,10) AS LIBRARY,
SUBSTR(TABNAME,1,10) AS TABLE,
TRIGTIME AS TRIGGER_TIME,
CREATE_DTS AS CREATED,
SUBSTR(TRIGPGM,1,10) AS TRIGGER_PROGRAM,
SUBSTR(TRIGPGMLIB,1,10) AS PROGRAM_LIBRARY,
OPERATIVE,
ENABLED,
SUBSTR(DEFINER,1,10) AS CREATE_USER,
EVENT_U AS ON_UPDATE,
EVENT_I AS ON_INSERT,
EVENT_D AS ON_DELETE,
TRIGNAME AS TRIGGER_NAME
FROM QSYS2/SYSTRIGGER
WHERE TABSCHEMA = 'MYLIB'
and TABNAME = 'MYTABLE'
No comments:
Post a Comment
NO JUNK, Please try to keep this clean and related to the topic at hand.
Comments are for users to ask questions, collaborate or improve on existing.