MVSFORUMS.com

[vijay]

Hi,

If I update a column c1 for key k1 and do a select after the update in the same program,would I see the updated value in column c1 all the time?

I tried a sample program like this and I always see the updated values in the select,though I did not do a explicit commit.Please help me understand how this works?

My bind card has isolation level CS.

PERFORM A100-UPDATE
THRU A100-EXIT.

PERFORM 10 TIMES
PERFORM A200-SELECT
THRU A200-EXIT
END-PERFORM.






Thanks,
Vijay

[jsharon1248]

It's part of your unit of work. You change it in your unit of work, you'll see the changed value when you select it. If you need the old values, you need to get them before the update.