topic regarding lock database table in Application Development and Automation Discussions

regarding lock database table

Former Member — Tue, 04 Sep 2007 11:35:32 GMT

Hello expert.

below is my requirement.

while count <> 0.

do some processing to fill wa_tab.

append wa_tab to i_tab.

endwhile.

modify db_tab from table i_tab.

Now i want to lock records at the time of update database record.

please let me which one of below code is right and gud in performance.

while count <> 0.

do some processing to fill wa_tab.

append wa_tab to i_tab.

lock entry in wa_tab. using lock object.

endwhile.

modify db_tab from table i_tab.

loop at i_tab into wa_tab.

unlock entry of database entry using wa_tab

endloop.

while count <> 0.

do some processing to fill wa_tab.

append wa_tab to i_tab.

endwhile.

lock the comple table

modify db_tab from table i_tab.

unlock complete table.

please add something if it is required and not there in the above pseudo code

thanks in advance for ur valuable help.

Re: regarding lock database table

Former Member — Tue, 04 Sep 2007 11:42:12 GMT

Hi,

In the First step also, lock the complete table

Regards

Sudheer

Re: regarding lock database table

Former Member — Tue, 04 Sep 2007 12:11:14 GMT

Hi,

In this case you can use the F.Ms ENQUEUE and DEQUEUE

while count <> 0.

do some processing to fill wa_tab.

append wa_tab to i_tab.

endwhile.

CALL FUNCTION 'ENQUEUE_EXXXX'

modify db_tab from table i_tab.

if sy-subrc = 0.

write : 'Records are succ updated'.

endif.

CALL FUNCTION 'DEQUEUE_EZVIJ'

Suppose if ur updating Z-table check whether lock objects has created or not, if not you can create the lock object by using SE11.

Reward with points if useful.

Regards,

Vijay

Re: regarding lock database table

Former Member — Tue, 04 Sep 2007 12:58:06 GMT

Do not locfk the complete table! Always lock only as little as necessary. Sooner or later you want to run your programm in parallel (multi-user), then the locking of the complete table will stop the second user.

Use insert or update if possible, and modify only if you do not know whether records exist already!

Siegfried

Re: regarding lock database table

RaymondGiuseppi — Tue, 04 Sep 2007 13:08:35 GMT

Theoretically do something like

*   Fill table when locking records
    LOOP.
      " some processing
      PERFORM lock record. " ENQUEUE
      " some processing again
      APPEND record TO update_table.
    ENDLOOP.
*   Call in update task a Function Module (just UPDATE from table in it)
    CALL FUNCTION 'Zupdate' IN UPDATE TASK
      table
        update_table = update_table.
*   Validate
    COMMIT WORK. " don't wait, 
*   the task will update data and release locks

Regards