topic Re: Insert statement with Commit work in Application Development and Automation Discussions

Insert statement with Commit work

Former Member — Fri, 19 Dec 2008 05:00:18 GMT

Dear all,

I have used insert statement for inserting the data into ztable ,I didnt used Commit work for commit the insertion , but the data is present in Ztable.

Is insert statement will work without Commit work. Please give the reason.

Thanks and Regards ,

Rajesh

Re: Insert statement with Commit work

Former Member — Fri, 19 Dec 2008 05:02:53 GMT

HI,

If you don't do an explicit commit / rollback in your program, when you exit your program the system will do the commit for you - this is one example of an implicit commit. Implicit commits will be activated at other points also eg when you call a popup screen.

refer to this link...

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3b64358411d1829f0000e829fbfe/content.htm

Re: Insert statement with Commit work

Former Member — Fri, 19 Dec 2008 05:04:00 GMT

Hi,

Insert statement will work without Commit work.

The main advantage of insert statement is insert data into database table as wel as Ztables also

Press F1 on insert statement u found all details of insert statement

How we can use insert statement with examples....

Re: Insert statement with Commit work

Former Member — Fri, 19 Dec 2008 05:10:58 GMT

Thanks .Well answered

Re: Insert statement with Commit work

Former Member — Fri, 19 Dec 2008 05:11:17 GMT

HI.

Acutally ,The INSERT statement is used to insert values into a single database table.No need Explicitly COMMIT WORK and ROLLBACK WORK .SAP already have done Implicitly commit work.

Regards.

Jay