topic Re: Locking data Base table in Application Development and Automation Discussions

Locking data Base table

Former Member — Thu, 26 Feb 2009 06:59:16 GMT

Hello fiends,

Please tell me, is it necessary to DEQUE the table after using ENQUE.

i have locked table fields using ENQUE function module. but i am not using DEQUE to release them. still those r getting released. how it is possible? is it necessary to use DEQUE immediately after ENDUE?

Kumar.

Re: Locking data Base table

Former Member — Thu, 26 Feb 2009 07:03:47 GMT

hi.....

its not mandatory to use DEQUE after you have done with ENQUE function module.

it takes into consideration LWU ie logical unit of work at the end of which locks get released.

and it happens also at the end of the progarm

regards

Re: Locking data Base table

RaymondGiuseppi — Thu, 26 Feb 2009 07:09:39 GMT

No, the lock is restricted to current [LUW|http://help.sap.com/abapdocu/en/ABENSAP_LUW.htm], and depending on scope parameter used in ENQUEUE call, the lock will be released by ROLLBACK WORK, COMMIT WORK or implicit end of LUW. Look at [SAP Locks |http://help.sap.com/abapdocu/en/ABENSAPLOCK.htm] for more details on _scope parameter effect.

Regards