For those DBMSs and database interfaces that support it (ODBC, SYJ, and JDB), AutoCommit controls whether PowerBuilder issues SQL statements outside or inside the scope of a transaction. When AutoCommit is set to False (the default), PowerBuilder issues SQL statements inside the scope of a transaction. When AutoCommit is set to True, PowerBuilder issues SQL statements outside the scope of a transaction. AutoCommit is set using the AutoCommit Mode check box on the Connection tab in the Database Profile Setup dialog box or by giving it a value in a PowerBuilder application script.
However, if the component you are developing participates in an EAServer transaction, the AutoCommit setting is ignored. Instead, EAServer determines how the component’s database operations execute as part of the transaction.
