Skip to Content
0

SAP HANA Procedure AUTOCOMMIT OFF

Feb 15 at 04:05 PM

43

avatar image
Former Member

Hi all,

we have a problem with a procedure on SAP HANA database.

We want to get autocommit off before upserting data in our custom table, is it possible to make this using a simple procedure?

Following this way, EXEC('commit') will be done as last statement to confirm data.

Thanks in advance.

Regards.

Dario.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Feb 16 at 06:16 AM
1

AUTOCOMMIT is a connection-related setting. That means it depends on your current database connection.

It is not possible to change it within a running connection, so you cannot have a procedure change that setting for you.

For your scenario, it should be clear that autocommit works after each client-command. That is, when you call a procedure, the commit only happens once this call comes back, but not after each command that had been executed by the procedure (or other procedures that the "main" procedure called in-between).

Share
10 |10000 characters needed characters left characters exceeded