topic Re: multiple updates on a database - concurrent updates in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/multiple-updates-on-a-database-concurrent-updates/m-p/4023273#M961458 <HTML><HEAD></HEAD><BODY><P>you need to create a lock object and handle.. them before updating the data...</P><P></P><PRE><CODE>* Lock the table CALL FUNCTION 'ENQUEUE_E_TABLE' EXPORTING mode_rstable = 'E' tabname = p_table EXCEPTIONS foreign_lock = 1 system_failure = 2 OTHERS = 3. IF sy-subrc = 0. * Modify the database table with these changes MODIFY (p_table) FROM TABLE &lt;dyn_tab_temp&gt;. REFRESH &lt;dyn_tab_temp&gt;. * Unlock the table CALL FUNCTION 'DEQUEUE_E_TABLE' EXPORTING mode_rstable = 'E' tabname = p_table.</CODE></PRE><P></P><P>Edited by: Jay Sadaram on Jun 23, 2008 1:21 AM</P></BODY></HTML> Mon, 23 Jun 2008 08:16:50 GMT former_member156446 2008-06-23T08:16:50Z multiple updates on a database - concurrent updates https://community.sap.com/t5/application-development-and-automation-discussions/multiple-updates-on-a-database-concurrent-updates/m-p/4023272#M961457 <HTML><HEAD></HEAD><BODY><P>hi Gurus,</P><P></P><P>i have a Remote enabled Function module which updates a Zee table. This function module is called by many systems(more than 15 systems) at the same time. </P><P></P><P>My problem is, how do i maintain consistency of the data being updated? </P><P></P><P>is Lock Tables concept going to help me in any way. please suggest a possible solution.</P><P></P><P>Rambo</P></BODY></HTML> Mon, 23 Jun 2008 08:15:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/multiple-updates-on-a-database-concurrent-updates/m-p/4023272#M961457 Former Member 2008-06-23T08:15:33Z Re: multiple updates on a database - concurrent updates https://community.sap.com/t5/application-development-and-automation-discussions/multiple-updates-on-a-database-concurrent-updates/m-p/4023273#M961458 <HTML><HEAD></HEAD><BODY><P>you need to create a lock object and handle.. them before updating the data...</P><P></P><PRE><CODE>* Lock the table CALL FUNCTION 'ENQUEUE_E_TABLE' EXPORTING mode_rstable = 'E' tabname = p_table EXCEPTIONS foreign_lock = 1 system_failure = 2 OTHERS = 3. IF sy-subrc = 0. * Modify the database table with these changes MODIFY (p_table) FROM TABLE &lt;dyn_tab_temp&gt;. REFRESH &lt;dyn_tab_temp&gt;. * Unlock the table CALL FUNCTION 'DEQUEUE_E_TABLE' EXPORTING mode_rstable = 'E' tabname = p_table.</CODE></PRE><P></P><P>Edited by: Jay Sadaram on Jun 23, 2008 1:21 AM</P></BODY></HTML> Mon, 23 Jun 2008 08:16:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/multiple-updates-on-a-database-concurrent-updates/m-p/4023273#M961458 former_member156446 2008-06-23T08:16:50Z