Reputation: 1
In an ABAP-based system, SET TRANSACTION AUTOCOMMIT DDL Statement Specifies the auto commit property for DDL statements specific to the session.
SET TRANSACTION AUTOCOMMIT DDL ON;
However, I see in the note 2560888 - SAP HANA 'SET TRANSACTION' SQL calls are no longer permitted:
Solution
There are the following functions in the classCL_SQL_CONNECTION
that can be used instead:
AUTOCOMMIT_DDL
So, does anyone know if AUTOCOMMIT_DDL
works on an ABAP-based system, non-Hana system please?
Upvotes: 0
Views: 234
Reputation: 10396
AUTOCOMMIT DDL
is a database session setting specific to SAP HANA. Other DBMS, e.g. Oracle don’t support DDL without implicit commits.
Upvotes: 0