Lock Object

[Former Member]

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.

[andreas_mann3]

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

[Former Member]

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....

[Former Member]

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,