how to switch off auto commit mode with SQL statment or hana studio.

[Former Member]

Hi expert:

Could you please tell me on how to switch off auto commit mode of hana db Rev50 in hana studio?

Thanks and Regards.

Jian Wu

[former_member184768 · Accepted solution]

Hi Jian,

Very simple.. Please go to your SQL editor and click on the Show Properties window. It should be there on the right hand side bottom. Change the property for Session -> Auto Commit to "Off" from "On".

Regards,

Ravi

[Former Member]

Jian,

You can turn Auto Commit to 'off' in the Properties Tab under the SQL editor in the SAP HANA Studio (Mine is Rev 38). and updated to 52 just now Follow below navigation

Open HANA Studio > Click on SQL Editor > below half you can see properties and under session Auto Commit will be on; you can make it off.

Hope this help you !

[Former Member]

All,

Thanks you all. That is helpful so far.

One more quesion, is that possible to shutdown session auto_commit mode thought sql statement like this: set autocommit off? Any approach to shutdown global auto_commit mode?

Jian

[lbreddemann]

Hi Jian,

there is no such thing as "global auto_commit mode".

The commit mode is a pure client setting and by default the HANA studio and hdbsql start with autocommit on.

For hdbsql you can easily just specify via command or command line parameter (-z) that you don't want autocommit to be active.

For HANA studio you can change the "Preferences"-> "Administration Console" -> "SQL" -> "Auto commit mode"-parameter to change the setting for all newly opened SQL windows.

- Lars

[Former Member]

Hi Lars,

Thanks for your tip, it is very helpful.

Jian

[Former Member]

Hi Lars,

very helpful answer, thanks!

Do you have any suggestion, how to switch off AUTO COMMIT, when you´re accessing HANA via a third party tool, like IBM Data Manager for example to trigger a stored procedure.

Regards, Christoph.

[lbreddemann]

Hi Christoph,

please don't hijack threads that have been answered and been dead now for years.

Just open a new thread instead. Doesn't cost a cent more.

- Lars