Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  Data Consistency →  Database LUW 

COMMIT, ROLLBACK CONNECTION

Short Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax


COMMIT|ROLLBACK CONNECTION con.

Effect

This COMMIT or ROLLBACK command executed on the secondary database connection specified using con performs a database commit or database rollback. Here, con is the name of the database connection, as specified in the table DBCON in the column CON_NAME. The con database connection can also be specified dynamically in the (source_text) form, where the source_text field contains the name of the database connection. The source_text field must be of the type c or string.

The database commit has the following effects on the specified secondary database connection:

  • all open database cursors are closed (OPEN CURSOR)
  • all database locks are released.

    • The statements COMMIT CONNECTION and ROLLBACK CONNECTION do not close the current SAP LUW.


    Notes

    • It should be noted that the statement COMMIT CONNECTION DEFAULT performs a pure database commit on the DEFAULT connection, unlike the statement COMMIT WORK.
    • Entries in the DBCON database tables can only be created or changed using the DBA Cockpit tool.