topic Re: Lock Object in Application Development and Automation Discussions

Lock Object

Former Member — Thu, 08 Jun 2006 09:54:48 GMT

Hi,

Can we create a lock on any data base object with out creating a lock object. i.e is there any generic way to lock data base objects?

Thanks.

Re: Lock Object

andreas_mann3 — Thu, 08 Jun 2006 09:57:21 GMT

yes,

try fm ENQUEUE_E_TABLE

example:

  sptab-tabname = 'ZTAB001'.
  sptab-varkey  = sy-mandt.
*
  CALL FUNCTION 'ENQUEUE_E_TABLE'
       EXPORTING
            tabname        = sptab-tabname
            varkey         = sptab-varkey
       EXCEPTIONS
            foreign_lock   = 1
            system_failure = 2
            OTHERS         = 3.

  IF sy-subrc <> 0.
    MESSAGE x030(zzz1) WITH sptab-tabname.
  ENDIF.

Andreas

Re: Lock Object

Former Member — Thu, 08 Jun 2006 09:59:26 GMT

fm used...<b>ENQUEUE_E_TABLE</b>

ex...

*----

lock Table

CALL FUNCTION 'ENQUEUE_E_TABLE'

EXPORTING

tabname = table_name

EXCEPTIONS

foreign_lock = 1

system_failure = 2

OTHERS = 3.

*----

Unlock Table

CALL FUNCTION 'DEQUEUE_E_TABLE'

EXPORTING

tabname = table_name

refer for more....

Re: Lock Object

Former Member — Thu, 08 Jun 2006 10:04:26 GMT

Hi,

To lock and unlock the data base table:

*----

lock Table

CALL FUNCTION 'ENQUEUE_E_TABLE'

EXPORTING

tabname = table_name

EXCEPTIONS

foreign_lock = 1

system_failure = 2

OTHERS = 3.

*----

Unlock Table

CALL FUNCTION 'DEQUEUE_E_TABLE'

EXPORTING

tabname = table_name

Regards,