topic Lock the whole table in Application Development and Automation Discussions

Lock the whole table

Former Member — Fri, 10 Jul 2009 14:00:22 GMT

Hello,

I'm deleting a lot of records from a Z table but I want to block the whole table first. I already have a lock object for that

Is this correct to lock the entire table?

CALL FUNCTION 'ENQUEUE_Exxxxx'

EXPORTING

MODE_ZNS032EXTRHIST = 'E'

EXCEPTIONS

FOREIGN_LOCK = 1

SYSTEM_FAILURE = 2

OTHERS = 3.

Or should I specify any other exporting parameter?

Thanks in advance!

Re: Lock the whole table

Former Member — Fri, 10 Jul 2009 14:04:00 GMT

Hi,

Mode E should be sufficient.

Pass the client also.

Regards,

Ankur Parab

Edited by: Ankur Parab on Jul 10, 2009 7:35 PM

Re: Lock the whole table

Former Member — Fri, 10 Jul 2009 16:00:07 GMT

hi, you can use

CALL FUNCTION 'ENQUEUE_E_TABLEE'

or Fm VIEW_ENQUEUE passing action as E when locking

thanks

Re: Lock the whole table

Former Member — Fri, 10 Jul 2009 20:02:50 GMT

Hi there,

I am not sure i got your requirements correctly.

The enqueue function module would just lock your table against any other requests to update/modify the table records untill you dequeue the table again.

If this is your requirement then the format mentioned by you is correct and this would lock the entire table.

Regards,

Jacky.