11-20-2007 2:12 PM
can anybody explain in brief about implicit commit and explicit commit and the difference between them and the procedure to work with it in REAL TIME..
11-20-2007 2:58 PM
Shortly....Generally there two ways to manage the commit. The first one is being done in automatic way, it means every process PAI, message, POPUP, end of program generates commit. The second one is being managed by programmer. Everything depends on the way you conduct the database update. If you use ( for update - insert, update, delete etc) a function module of type "Update module" (CALL FUNCTION IN UPDATE TASK) or FORMS (PRFORM ON COMMIT) you will decide when commit is to be done. You have to type COMMIt WORK or COMMIT WORK AND WAIT. In other cases the system triggers the commit (as described above).
Best Regards
Adam
11-20-2007 2:58 PM
Shortly....Generally there two ways to manage the commit. The first one is being done in automatic way, it means every process PAI, message, POPUP, end of program generates commit. The second one is being managed by programmer. Everything depends on the way you conduct the database update. If you use ( for update - insert, update, delete etc) a function module of type "Update module" (CALL FUNCTION IN UPDATE TASK) or FORMS (PRFORM ON COMMIT) you will decide when commit is to be done. You have to type COMMIt WORK or COMMIT WORK AND WAIT. In other cases the system triggers the commit (as described above).
Best Regards
Adam
11-20-2007 3:02 PM
I've forgotten about COMMIT AND WORK. In such case all database changes are being done asynchronous. You don't have to wait until the end of the update. If something goes wrong with update ypu can check it with help of transaction SM13.
Adam