topic Re: update enque deque in Application Development and Automation Discussions

update enque deque

Former Member — Fri, 27 Dec 2013 06:47:55 GMT

I need to update two database tables using update statement .

I know enque deque is needed before update modify etc operations with databse tables

my question is if enque deque is not used what is the performance impact and implications ( the database table is locked so that multiple user performing same operations or using same database update application does not results in conflicts ) but I have checked in backend only once the application is executed fully the update is done for eg first update return is sy-subrc = 0 (in debugging mode ) and second update statement is executed only when the program is closed and run full the update to database is visible in data base elsewise the update is not done even if first update on first table has sy-subrc = 0.

also update statement locks the database tables automatically as checked in sm12 so is there need for enque deque really or it is just a performance and code review practice.

pls suggest

regards

Nishant

Re: update enque deque

nabheetscn — Fri, 27 Dec 2013 07:15:05 GMT

Please read about why do we need locks to understand in detail. Read about implicit commits also

Re: update enque deque

RemiKaimal — Fri, 27 Dec 2013 08:01:07 GMT

Hello Nishant ,

Please try updating the tables using Update function modules.

1) You can either call update the tables in two separate Update function modules

= or =

2) Two update statements with the same Update function module

3) Within the Update function module, you can decide on the type of updation to be :

Synchronous / Asynchronous

CALL FUNCTION 'XXX' IN UPDATE TASK

Hope this helps..

Cheers,

Remi