ARTICLE
Database LUWs
For each open database connection that can be represented by an instance
of class CL_SQL_CONNECTION , only
one database LUW can be active at
any one time. When a connection is opened, the first database LUW
of the connection is opened implicitly.
Class CL_SQL_CONNECTION contains instance methods
COMMIT ,
ROLLBACK ,
These end the current database LUW of a connection by means of a
database commit or a
database rollback and open a
new database LUW .
The database LUWs of different connections are independent of one
another and must be ended individually. When the work process is s
witched, with the resulting implicit database
commit , this is executed on all open connections. The database
commit on the default connection takes place last of all.
Notes
To execute a database commit or a database rollback on the
default connection using ADBC , an instance of class
CL_SQL_CONNECTION must be created for this connection using
CREATE OBJECT .
Transaction control is possible only using the methods COMMIT and
ROLLBACK of the class CL_SQL_CONNECTION , since only in
this case are all actions required at the end of the transaction
executed in the database interface. The statements COMMIT or
ROLLBACK should not be executed using CL_SQL_STATEMENT or
CL_SQL_PREPARED_STATEMENT , to avoid critical side effects.
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved