Skip to Content

Does it needs COMMIT WORK explicitly every time?

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2012 at 12:35 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.