Enqueue and Dequeue before updating Database table

[Former Member]

Hi all,

We are updating database tables using INSERT, MODIFY and UPDATE statements. Since many people will be running the application at the same time we need to lock the table before updating database table. So we need to use ENQUEUE and DEQUEUE functionality for this purpose.

Can any plz explain what are the steps we should follow now?

Thanks in advance.

[Chaitanya_Priya]

Hi,

To use locking concept the steps to be followed are:

1.Go to SE11 and create a lock object .(for eg:EZLOCK_OVERALL)

2. Creation of lock object automaically generates function modules

enqueue and dequeue.(so for this example it generates ENQUEUE_EZLOCK_OVERALL DEQUEUE_EZLOCK_OVERALL)

while using these function modules first the procedure for locking is

Lock the data base table,Read/Write the entry ,Unlock the Database table.

You refer to the below links :

[http://help.sap.com/saphelp_nw04/helpdata/EN/7b/f9813712f7434be10000009b38f8cf/content.htm][http://help.sap.com/saphelp_nw70/helpdata/en/41/7af4c8a79e11d1950f0000e82de14a/content.htm]

[http://help.sap.com/search/highlightContent.jsp]

Regards,

Priya

[Former Member]

hi,

Refer this thread: