Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Does it needs COMMIT WORK explicitly every time?

former_member202077
Participant
0 Kudos

Hello

Does ABAPers need to put/use COMMIT WORK statement after each and every DB statement if the data base is DB2?

As far i knew, in Oracle we use COMMITM WORK only when we do a INSERT/UPDATE/MODIFY/DELETE to Oracle DB.

But, for DB2 we need to use COMMIT WORK after each and every SELECT SQL? like other data base associated staements?

Thank you

Moderator message: please find and study available information/documentation on SAP LUW concept.

Message was edited by: Thomas Zloch

1 REPLY 1

Former Member
0 Kudos

As far as I know,  COMMIT does not depend on the underlying database. COMMIT is part of SAP Transaction concept.

http://help.sap.com/saphelp_nw70/helpdata/en/41/7af4b6a79e11d1950f0000e82de14a/content.htm

The Native SQL drivers in SAP takes care of writing the data to the database.

So what ever native SQL operations that must be performed for each DB will be performed by SAP Sql drivers and you just have to worry about the OPEN SQL commands.

Thanks,

Shambu