MVSFORUMS.com

[deeptik]

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.

[kolusu]

deepthik,

1. Open cursor on table T1
2. Fetch cursor
3. Issue update on table t2

[deeptik]

Yes, this method can be used . I am trying to find if this entire process can be done by using cursors or is there any other way of doing this .

[kolusu]

deeptik,

You can also unload all the 4 tables in question and run the files thru utility/pgm and generate the updated record and load them back

Kolusu