The CICS, Encina, or TUXEDO TM is responsible for transaction management. This includes creating a global transaction in which all of an application’s work is either committed or rolled back. Consequently, applications cannot issue SQL statements that manage transactions.
Specifically, applications cannot invoke the following Embedded SQL commands:
begin transaction
commit
rollback
Client-Library applications cannot execute (via ct_command, ct_dynamic, or ct_cursor) any of these Transact-SQL commands:
begin transaction
commit transaction
rollback transaction
set (chained, noexec, isolation, parseonly, statistics io, statistics time)
save transaction
The application must recognize Adaptive Server–detected
errors, and abort or roll back the transaction through the TM. This is especially important for Adaptive
Server detected-deadlocks.
