Perform a COMMIT during a DB lock

[Former Member]

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

[Former Member]

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

[Former Member]

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