trigger to update
My Table Structure is:Table A Table B Table CcolA -PK Col B-PK Col C-PKCol B-FK Col B-FKCol C-FKThis relation establish a Concurrent relation where in Cascade Property fails.I can set Cascade property for any two tabnles...but not the third table.My requirement is :1)To Update PK of Table BOn...
View Answer
| Feb 13 2008 4:54 AM GMT
| asked by
Adithi
Trigger, SQL
left outer join in trigger DB2 Z/OS
I'm having problems writing a trigger that contains a left outer join. Here is the trigger: CREATE TRIGGER H000.H0TRCAD2 AFTER DELETE ON H000.H0COO_TRANS_CALLC REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SELECT OLD_ROW.CLNT_ID , OLD_ROW.ACCT_NBR , OLD_ROW.PST_DT ,...
Answer Question
| Feb 7 2008 3:34 PM GMT
| asked by
X00005
DB2, z/OS, Trigger


