topic Re: Perform a COMMIT during a DB lock in Application Development and Automation Discussions

Perform a COMMIT during a DB lock

Former Member — Tue, 16 Feb 2010 21:38:05 GMT

Hi experts,

I have locked certain fields of a DB table using a lock object (called the FM ENQUEUE_XXXX). After successfully executing the FM, I need to update a table which is not affected by the lock object and save the changes with a COMMIT WORK. Things are not working as I wish because in debugging mode I have observed that the table is updated after I release the lock object (call FM DEQUEUE_XXXX). Can it be that I'm setting a wrong parameter during the call of the FM ENQUEUE_XXXX? The lock type I'm setting is E.

Thanks in advance for your help,

Jaime

Re: Perform a COMMIT during a DB lock

Former Member — Tue, 16 Feb 2010 21:57:45 GMT

Moderator message - Welcome to SCN.

SAP locks using ENQUEUE and DEQUEUE FMs are logical locks not physical. But a COMMIT is hard. once you do a COMMIT, the database should be updated. How do you tell that it is not?

Rob

Re: Perform a COMMIT during a DB lock

Former Member — Tue, 16 Feb 2010 22:42:19 GMT

Hi Rob,

I'm taking a look at the content of the table with the transaction SE16. The record is only updated after performing the DEQUEUE.

Regards,

Jaime