How to lock a database Z table before updating it through a report program

[Former Member]

Hi,

How to lock a database Z table before updating it through a report program and also how to unlock it after my updation.

The whole process is done through report program.

[Former Member]

you can use two function modules..

ENQUEUE_table name to lock

DEQUEUE_table name to unlock

Regards

Ansari

[Former Member]

Hi,

But when call the function module enqueue_Ztablename,

I am getting a message saying function module does not exist.

pls help me out

Thanks&Regards,

Sandeep

[Former Member]

make a lock object in se11, with name starting with EZ* or EY* for your ztable

then use enquque_ez* FM to lock ztable record

and use dequeue_ez* FM to unlock ztable record

[Former Member]

Hi,

Go to SE11, in the option 'Lock object' enter the name of your lock,

begin with 'E', suppose 'EXXXX' And create. In tab 'Tables' fill the

table name where the record you want to lock exist and select the

lock mode. Lock mode can be shared and exclusive. If 'shared',

when you lock the record, other can also read data, but can not

modify. If 'exclusive', when you lock the record, other can neither

read nor modify the record. After save and activate, you will get two

function module.'ENQUEUE_EXXXX' to lock record,

'DEQUEUE_EXXXX' to release lock on one record.

When use this function module it only lock one record at a time. It

does not lock the table.

Regards,

Omkaram.

[Former Member]

Hi Omkaram,

Thank you soo much.

Its working.

Thanks & Regards,

Sandeep Kishan