topic Re: Table locking for Update in Application Development and Automation Discussions

Table locking for Update

Former Member — Wed, 01 Apr 2009 15:48:47 GMT

Hi All,

I have one doubt...Iam updating the Table using UPDATE statement..is it mandatory to use Table locking befoe updating the table.

For DELETE..no need to use table locking..iam sure but for UPDATE is it required or not. Please help me..

Since iam facing the issues with table locking i posted this one.

Re: Table locking for Update

Former Member — Wed, 01 Apr 2009 15:52:05 GMT

HI,

For every database operation you require to have the locking system . When you are updating or modifying the database record then at the same time no one should try to modify this data so in this case you need to lock the entry.

Even in case of Delete if some one is trying to modify the same entry which you deleting.. so to overcome this you need to have locking.

Re: Table locking for Update

Former Member — Wed, 01 Apr 2009 18:02:44 GMT

hi sreehari,

Table locking is important before updating or modifying ir deleting the record.

because if some is opened table maintainence view for that table the record if you want to delete or update or modify it will not work.

so if it is a custom table create lock object for primary key field

E_(custom table name)..

Automatically it creates two function modules with name 'ENQUEUE_(lock object created) &'DEQUEUE_(lock object created).

so when ever you update for delete the particular record

use CALL FUNCTION 'ENQUEUE_(lock object created) "To lock record

-->then delete or modify

Use CALL FUNCTION 'DEQUEUE_(lock object created) "To unlock Record.

Regards,

Prabhudas

Re: Table locking for Update

Former Member — Wed, 01 Apr 2009 18:45:58 GMT

If there is no possibility of someone else accessing a table entry when you are updating, there is no need to lock.

Rob

Re: Table locking for Update

Former Member — Mon, 25 May 2009 13:47:14 GMT

Hi Sreehari,

Try this to lock the rows. The rows are unlock after do commit.

SELECT SINGLE FOR UPDATE *

INTO wa_table

FROM table

WHERE ......

AND ......

AND .......

Hope this information is help to you.

Regards,

José

Re: Table locking for Update

Peranandam — Tue, 26 May 2009 00:45:55 GMT

generally we are locking ztable entries before doing updation for avoiding inconsistancy. lock applicable depending upon table utilization in business point of view.

Good porgrame manner is to lock the table before doing updation activity.

create lock object for your ztable and call lock module(ENQEUE AND DEQUEUE) within your application program. or call FM ENQUEUE_E_TABLE for locking ztable without creating lock object.

Regards,

Peranandam