|
|
|
|
|
set chained {on | off}
Enables or disables chained transaction mode for the current session. In chained transaction mode, a select, insert, update, delete, fetch or open statement implicitly starts a transaction, but the programmer has to issue the commit statement.
Example
set chained on
-- Start of transaction
update T_Part set Description = ‘Unshielded twisted pair’
where PartCode = 'UTP CABLE'
commit