Ansicht
Dokumentation

DB_RESET_ISOLATION_TO_DEFAULT - DB-independent FM, sets isolation level to default value

CPI1466 during Backup   General Data in Customer Master  
This documentation is copyright by SAP AG.

Functionality

This function module allows the R/3 default level to be activated explicitly. This makes it possible to take an activated committed level back to the default level (call to function module DB_SET_ISOLATION_LEVEL) before the end of the transaction.

Example

REPORT ISOTEST .
TABLES: SBTST.
********** switch to committed level *************
CALL FUNCTION 'DB_SET_ISOLATION_LEVEL'. ********************************************************
*from now on committed level at least aplies
SELECT SINGLE FOR UPDATE * FROM SBTST WHERE K1 = 1.
.....
SELECT SINGLE FOR UPDATE * FROM SBTST WHERE K1 = 99.
********** explicit switch to R/3 default ********
CALL FUNCTION 'DB_RESET_ISOLATION_TO_DEFAULT'. ********************************************************
*from now on R/3 default level applies again
SELECT SINGLE FOR UPDATE * FROM SBTST WHERE K1 = 100.
SELECT SINGLE FOR UPDATE * FROM SBTST WHERE K1 = 101.
.....

Notes

Further information

See also function module DB_SET_ISOLATION_LEVEL

Parameters

CON_NAME

Exceptions

CONNECTION_ERROR
INTERNAL_ERROR
NOT_SUPPORTED

Function Group

SDB4

CL_GUI_FRONTEND_SERVICES - Frontend Services   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 1365 Date: 20240523 Time: 114120     sap01-206 ( 23 ms )