Transactions
The DB Access Module for ODBC implements the model of transaction processing of the DB Interface Module through calls to SQLSetConnectAttr() and SQLEndTran().
NOTE: Your database may limit the types of statements you can execute inside a transaction.
We are aware of at least one driver that implicitly makes DDL calls before each SQLExecute() call. For such a driver, transaction processing is effectively disabled. Chapter 23, “Updating Data in Multiple Tables,” in the DB Interface Module User's Guide, is a tutorial for an application that can be used to test the transaction processing capabilities of your driver.