Transactions
MDS supports two types of one-phase commit transactions: implicit and explicit.
Both types of transactions will be implemented using the ANSI Teradata ODBC session mode and ODBC’s manual commit transaction interface. Using the ANSI session mode instead of Teradata’s native mode will allow MDS’s transaction to be more easily ported to other ANSI- and ODBC-compliant platforms. To facilitate this, MDS will avoid sending Teradata-specific transaction management SQL commands directly to Teradata, and will instead use the ODBC transaction APIs to manage transactions.