JMS
JMS

Reputation: 1

Does AUTOCOMMIT_DDL work on an ABAP-based system, non HANA system?

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 class CL_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

Answers (1)

Lars Br.
Lars Br.

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

Related Questions