topic Re: Database Locks in Application Development and Automation Discussions

Database Locks

Former Member — Sun, 12 Nov 2006 18:21:45 GMT

Hi all,

can any one send a piece of code for locking.(shared,exclusive..)

Regards

vijaya

Re: Database Locks

raja_thangamani — Sun, 12 Nov 2006 18:56:05 GMT

Vijaya,

How to lock and unlock object...

fm used...ENQUEUE_E_TABLE

Ex...

Lock Table

CALL FUNCTION 'ENQUEUE_E_TABLE'

EXPORTING

tabname = table_name

EXCEPTIONS

foreign_lock = 1

system_failure = 2

OTHERS = 3.

*-Unlock Table

CALL FUNCTION 'DEQUEUE_E_TABLE'

EXPORTING

tabname = table_name

Check these Threads...

http://help.sap.com/saphelp_nw04/helpdata/en/7b/f9813712f7434be10000009b38f8cf/content.htm

http://www.sap-img.com/abap/type-and-uses-of-lock-objects-in-sap.htm

http://www.guidancetech.com/people/holland/sap/abap/yusrlock.htm

http://www.sappoint.com/abap/ab4dict.pdf

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eef3446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/41/7af4c5a79e11d1950f0000e82de14a/content.htm

Re: Database Locks

Former Member — Mon, 13 Nov 2006 11:16:21 GMT

hello,

Lock

CALL FUNCTION 'ENQUEUE....'

EXPORTING

tabname = table_name

EXCEPTIONS

foreign_lock = 1

system_failure = 2

OTHERS = 3.

*-Unlock

CALL FUNCTION 'DEQUEUE...

EXPORTING

tabname = table_name

Regards,

shehryar

Re: Database Locks

anversha_s — Mon, 13 Nov 2006 11:19:14 GMT

hi,

Hi,

Lock objects are used to lock the database table while making the modifications on the database table.

you can create your own lock objects using SE11.

if you create lock objects on any table system will create two function modules.

1.ENQUEUE....

2.DEQUEUE.....

first one is used to lock the table

second one used to removing lock on the table.

*-------------lock Table
CALL FUNCTION 'ENQUEUE_E_TABLE'
EXPORTING
tabname = table_name
EXCEPTIONS
foreign_lock = 1
system_failure = 2
OTHERS = 3.
 
 
 
*-------------Unlock Table
CALL FUNCTION 'DEQUEUE_E_TABLE'
EXPORTING
tabname = table_name

check this link :

http://help.sap.com/saphelp_40b/helpdata/en/cf/21eea5446011d189700000e8322d00/content.htm

Rgds

Anver

if hlped pls mark points

Re: Database Locks

Former Member — Mon, 13 Nov 2006 11:37:40 GMT

If you are working with HR Tables, Please use below FM's for enqueue / dequeue HR Objects..

Unlock HR Objects HR_DEQUEUE_OBJECT

Lock HR Objects HR_ENQUEUE_OBJECT

Regards,

Ramki.