topic Commit After Insert or Update in Application Development and Automation Discussions

Commit After Insert or Update

Former Member — Mon, 15 Jun 2009 07:52:57 GMT

Hi,

Is it mandatory to write Commit Work after Insert or Update into DataBase Table.?

Without writing also it is working fine.

Can you please let me know..what is the exact significance of this.....

Please explain in Brief...

I have seen so many links...But dint get exactly ....what the significance is...

Thanks,

Sandip

Re: Commit After Insert or Update

Sandeep_Panghal — Mon, 15 Jun 2009 07:59:57 GMT

Commit work.

Will do an explicit db commit.

Both insert and update also perfom an implicit db commit.

The significance of explicit commitw ork comes in to picture when your DB updates faila nd you want to rollback .

So best way is to check sy-subrc after insert/update and if it fails then rollback work else do a commit.

Re: Commit After Insert or Update

Former Member — Mon, 15 Jun 2009 08:11:32 GMT

Hi Sandeep,

The COMMIT WORK statement always sets sy-subrc to 0 if the AND WAIT addition is not specified. It triggers a database exception in programs that are called using CALL DIALOG. This executes all high-priority (VB1) update function modules in the order of their registration and in a common database LUW.It triggers a database commit that also terminates the current database LUW and closes all database cursors.

If u r doing any operation in DB, to save that COMMIT used.

Thanks,

Sneha.

Re: Commit After Insert or Update

Former Member — Mon, 15 Jun 2009 08:22:40 GMT

U should read the information (or SAP Help) about LUW (Logical Unit of Work).

Here u can find out all answeres you need.

Max

Re: Commit After Insert or Update

Former Member — Mon, 15 Jun 2009 09:00:34 GMT

All the statements will be added to logical unit of work and this logical unit of work is submitted to database after periodic interval, if you want you can write COMMIT to have it done explicitly.

This is done when you want database to reflect new values instantonously.