There is a table T1. For each row of T1, I need to update tables T2, T3 and T4 in succession i.e if T2 update is successful, then update T3 and if T3 successful then T4 and so on. What is the shortest way to implement this logic in cobol db2 program.
Joined: 18 Jun 2007 Posts: 208 Location: Cochin/Kerala/India
I dont know it is the correct answer.sometimes i saw that if i insert a row in to one table the corresponding row will insert in to its child table automatically.I think if you check in the referential integrity topic .May be you will get something.
Excuse me if i'm wrong.