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 applied to the secondary database connection specifed in con triggers a database commit or rollback. 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 COMMIT CONNECTION and ROLLBACK CONNECTION statements do not close the current SAP LUW.


    Notes

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