Skip to Content

SAP HANA Procedure AUTOCOMMIT OFF

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 16 at 06:16 AM

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

    Add comment
    10|10000 characters needed characters exceeded