Updating an database table.

[Former Member]

I'm trying to update a table that is very dynamic.

since it is a dynamic table i'm trying to update each record seperately.

select * from s883 where with all the key conditio.

update s883 set 3 values(not key fields) where with the same key as above.

endselect .

commit work.

Problem here is all the updates will be stored in a bufeer till the commit work is called.

But in the mean time if any other program updates the s883 table then the data will be lost and becomes inconsistent.

Is there any way where we can commit the changes immediately.

[Former Member]

I'm trying to update a table that is very dynamic.

since it is a dynamic table i'm trying to update each record seperately.

select * from s883 where with all the key conditio.

update s883 set 3 values(not key fields) where with the same key as above.

endselect .

commit work.

Problem here is all the updates will be stored in a bufeer till the commit work is called.

But in the mean time if any other program updates the s883 table then the data will be lost and becomes inconsistent.

Is there any way where we can commit the changes immediately.

[Former Member]

Why dont you just use the update statement ...secondly you can also do is lock and unlock the table !!

Regards

Anurag

[Former Member]

Hi Phani,

Try using the Commitwork after update statement.

I hope this will work out.

Cheers,

Prashanth

[Former Member]

Hi Thanks for the replies.

I can't use update because there is some process going on in between and this piece of code is called inside a loop.

And regarding that commit work in the select endselect it closes the cursor and it is an exception.

Any other pointers?

[Former Member]

Lock and unlock the table before the select and after the commit.

In that case you would get consitent updates.

Regards

Anurag

[Former Member]

You can queue the table, use it and dequeue at the end

regards