SAP HANA Procedure AUTOCOMMIT OFF

[former_member452749]

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.

[lbreddemann]

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).