You know there is a GREAT DB2-specific list? Go to IDUG.org and you should be able to find it.
Charles -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Paulo Roberto Leonardo Pereira Sent: Friday, October 13, 2017 5:12 AM To: [email protected] Subject: Re: DB2 trigger Maybe something like this (I am ot sure): CREATE TRIGGER PU_UPD_PPSTA AFTER UPDATE OF LCR ON PPSTA REFERENCING OLD AS O NEW AS N FOR EACH ROW MODE DB2SQL BEGIN ATOMIC UPDATE HIST SET LCR.HIST = LCR.PPSTA END; Em 13/10/2017 8:38, Paulo Roberto Leonardo Pereira escreveu: > I need to know how can I get examples of triggers to update a > different table from an update on another one. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
