topic Re: Updating an database table. in Application Development and Automation Discussions

Updating an database table.

Former Member — Tue, 29 Aug 2006 10:36:35 GMT

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 — Tue, 29 Aug 2006 10:39:44 GMT

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

Regards

Anurag

Former Member — Tue, 29 Aug 2006 10:40:48 GMT

Hi Phani,

Try using the Commitwork after update statement.

I hope this will work out.

Cheers,

Prashanth

Former Member — Tue, 29 Aug 2006 10:50:39 GMT

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 — Tue, 29 Aug 2006 11:17:41 GMT

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

In that case you would get consitent updates.

Regards

Anurag

Former Member — Tue, 29 Aug 2006 11:52:22 GMT

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

regards