The fifth step is to call SQLEndTran to commit or roll back the transaction. The application performs this step only if it set the transaction commit mode to manual commit; if the transaction commit mode is auto-commit, which is the default, the transaction is automatically committed when the statement is executed. For more information, see Chapter 14, “Transactions.”
To execute a statement in a new transaction, the application returns to Step 3. To disconnect from the data source, the application proceeds to Step 6.