Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does AUTOCOMMIT work?

April 26, 2017autocommit

0

Posted

How does AUTOCOMMIT work?

1 Answer

0

Posted

AUTOCOMMIT means that the user of the CLI does not want to do any COMMITs or ROLLBACKs. Every executed statement should be automatically committed upon successful completion. Prior to V4R4, this was implemented by turning off commitment control. In other words, setting AUTOCOMMIT on was the same thing as setting the commit level to NONE. This means that files need not be journaled, and the user does not need to code their own commits and rollbacks. The limitations of this are that LOB locators cannot be accessed, and if the program calls an SQL stored procedure that does work under commitment control, those changes will not be committed. Prior to V4R4, those limitations may be a reason to not use AUTOCOMMIT. In V4R4, there is support for true AUTOCOMMIT processing. This means that the AUTOCOMMIT attribute and the commitment control level are completely independent.