topic Re: Commit work in Application Development and Automation Discussions

Commit work

Former Member — Tue, 19 Dec 2006 10:02:03 GMT

What is commit work?

Re: Commit work

Former Member — Tue, 19 Dec 2006 10:03:23 GMT

Hello,

COMMIT WORK is the key word to make the database change.

ROLLBACK is the opposite to commit work,

If useful reward.

Vasanth

Re: Commit work

Former Member — Tue, 19 Dec 2006 10:04:04 GMT

this statement will apply any outstanding database updates and wait until they have actually been put on the database before proceeding to the next statement.

An ordinary commit work will initiate the process to update the databases in a separate task and will press on in your abap.

COMMIT WORK: ( Asynchronous)

Your program does not wait for any acknowledgement. it just start executing the next statment after COMMIT WORK.

Re: Commit work

Former Member — Tue, 19 Dec 2006 10:04:15 GMT

Check this link

http://help.sap.com/saphelp_erp2005vp/helpdata/en/fc/eb3b64358411d1829f0000e

829fbfe/content.htm

Re: Commit work

Former Member — Tue, 19 Dec 2006 10:04:32 GMT

HI,

When you perform Commit , all the LUW s work will be reflected to the database.

Reward points if this Helps.

Manish

Re: Commit work

Former Member — Tue, 19 Dec 2006 10:04:52 GMT

Executes a database commit and thus closes a Logical Unit of Work ( LUW) (see also Transaction Processing). This means that

all database updates are made irrevocable and cannot be reversed with ROLLBACK WORK and

all database locks are released.

COMMIT WORK also

calls the subroutines specified by PERFORM ... ON COMMIT,

executes asynchronously any update requests (see CALL FUNCTION ... IN UPDATE TASK) specified in these subroutines or started just before,

processes the function modules specified in CALL FUNCTION ... IN BACKGROUND TASK,

closes all open database cursors (see OPEN CURSOR) and

resets the time slice counter to 0.

Never Use Commit work in a select... endselect .. program dumps..

Re: Commit work

Former Member — Tue, 19 Dec 2006 10:05:14 GMT

commit work is used to commit changes to the database ,when u are changing datbase say delete ,update ,insert ,u can always do commit work so that changes wil be comiited and even after rollback u can not revert them back later..

reward pls