work process for database updation

[Former Member]

hi ,

   how to make queue for database update based on priority,

  for example, program 1 and program 2 are updating same database table  at same time,

i want to update db table based on queue request thats after completing update from program 1,program 2 has to update,

how to achieve the same.

[Former Member]

Hi,

I suggest you to do table lock while doing updating the DB table.

This will prevent another program or another transaction to modify the same table.

Please check the below link for more details.

SAP Database Locking - ENQUEUE and DEQUEUE

You may check in your second program whether your table is locked or not. According to that you

may write the logic.

[nishantbansal91]

Hi,

Prog A.

Lock the table before updating and unlock the table after updating.

PROG B.

Check If the table is locked wait for 2 second or as per your requirement and check the same,

Thanks
Nishant

[Former Member]

thanks for ur reply.