The DB Access Module for ODBC implements the model of transaction processing of the DB Interface Module through calls to SQLSetConnectAttr() and SQLEndTran().
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.