MVSFORUMS.com

[ranjit5311]

Hi All,

There are two tables;-

TAB1(LAST_KEY, UPDATED_BY)

TAB2(ADDRESS_ID,UPDATED_BY)

LAST_KEY is a dynamic field. The value keeps on increasing. My requirement is to update the LAST_KEY to current value + 1. And this valuse should be updated in TAB2(ADDESS_ID).


I believe this can be achive in following way:-
1. lock table TAB1
2. Fetch the current value of LAST_KEY
3. update this LAST_KEY by 1
4. update the value in TAB2(ADDRESS_ID)
5.Release the lock TAB1.

But How the above steps cab be done in Spufi.

Please help me out to solve my query.

Thanks,
Ranjit Kumar
_________________
One should move lightly through the life, carrying no excess baggage.

[kolusu]

ranjit5311,

Try this

[videlord]

LOCK TASBLE TAB1 IN EXCLUSIVE MODE;
UPDATE TAB1 SET LAST_KEY = LAST_KEY + 1 WHERE ...
UPDATE TAB2 ....
COMMIT;

before the COMMIT statement, the table TAB1 is locked, no other DB2 thread can change the data in the table.