Updating Db2 tables in succession

deeptik · New User Joined: 21 Mar 2006 Posts: 8

Hi,

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.

thanks.

bipinpeter · Posted: Fri Jul 10, 2009 10:40 am

Hi deeptik,
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.

deeptik · New User Joined: 21 Mar 2006 Posts: 8

Ok, but here the requirement is to update other tables and not insert..

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Hi deeptik,
Just update the next(through basic perform) if the sqlcode is 0.