Ansicht
Dokumentation

ABENHANA_SET_TRANSACTION - HANA SET TRANSACTION

Addresses (Business Address Services)   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Setting Transaction Behavior for SAP HANA

• SET TRANSACTION AUTOCOMMIT DDL

• SET TRANSACTION ISOLATION LEVEL

• SET TRANSACTION LOCK WAIT TIMEOUT

• SET TRANSACTION READ ONLY$|WRITE

These statements modify the transaction behavior of the current database connection. They cannot be used directly by AS ABAP when accessing the SAP Hana database using Native SQL (ADBC, EXEC SQL). This is because transaction behavior defined for the current database connection using these settings is persisted beyond its current database LUW. If the database connection is then reused in , Native SQL, or AMDP (see Database Connections), unexpected or critical situations can arise. The following methods of the class CL_SQL_CONNECTION should be used instead:

• AUTOCOMMIT_DDL for SET TRANSACTION AUTOCOMMIT DDL

• SET_ISOLATION_LEVEL for SET TRANSACTION ISOLATION LEVEL

• SET_LOCK_WAIT_TIMEOUT for SET TRANSACTION LOCK WAIT TIMEOUT

• There is no current method available for SET TRANSACTION READ ONLY$|WRITE

These methods wrap the SQL statements. The HANA-specific part (Client Library) of the Native SQL interface registers any calls of these methods and resets the transaction behavior of the current database connection to the default behavior at the end of the current database LUW.

Notes

• In SQLScript (and hence automatically in the corresponding AMDP methods), the SQL SET TRANSACTION statements for setting transaction behavior are not allowed in the syntax.

• Currently, there are no automatic resets of the transaction behavior after method calls on any other database platforms.

ROGBILLS - Synchronize billing plans   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Length: 3328 Date: 20240425 Time: 123225     sap01-206 ( 44 ms )