COMMIT, ROLLBACK CONNECTION
COMMIT|ROLLBACK CONNECTION con|(con_syntax).
The following can be specified for
con or in
con_syntax (and transformed to uppercase letters internally):
defaultspecified statically or DEFAULT specified dynamically for the standard connection of the current work process.
- The name of secondary connection specified statically or dynamically. The name must exist in the column CON_NAME of the database table DBCON.
- The name of a service connection to the standard database specified statically or dynamically. The name of the service connection must consist of the prefix R/3* followed by any 26 alphanumeric characters (in uppercase).
A name (in uppercase letters) granted for a secondary connection or service connection by the addition
ASof the static Native SQL statement CONNECT TO. It should be noted here that a connection with a name of this type is a separate database connection that can exist in parallel with a connection not named using
It should also be noted that the statements
COMMIT CONNECTION defaultand
ROLLBACK CONNECTION defaultperform a clean database commit or rollback on the standard connection, unlike COMMIT WORK and
ROLLBACK WORK. They do not close the current SAP LUW.
ROLLBACK CONNECTIONare suitable for a simple close of a database LUW. If database LUWs are monitored by the application log, the function modules DB_COMMIT and DB_ROLLBACK are better suited to raising an appropriate event.
ROLLBACK CONNECTIONcan only be used to edit connections activated in Native SQL or AMDP if their names do not contain any lowercase letters. This affects service connections and names defined using the addition
ASof the statement
CONNECT TO. The names of secondary connections do not contain any lowercase letters.
ROLLBACK CONNECTIONclear global temporary tables on the specified secondary connection and prevent the runtime error COMMIT_GTT_ERROR in implicit database commits on this connection.
ROLLBACK CONNECTIONchange the state of an active secondary connection or service connection to inactive. The way the following connection is used in the same internal session opens a new database LUW.
Detailed information about database connections can be found here.
Performs a database commit and releases the exclusive lock after modifying ABAP SQL statements by using
COMMIT CONNECTION default on the standard connection.
DELETE FROM demo_expressions. INSERT demo_expressions FROM @( VALUE #( id = 'X' ) ). COMMIT CONNECTION default.