ASA Database Administration Guide
Database Options
Alphabetical list of options
Controls transaction mode in the absence of a BEGIN TRANSACTION statement.
ON, OFF
ON
OFF for Open Client and JDBC connections
Controls the Transact-SQL transaction mode. In Unchained mode (CHAINED = OFF), each statement is committed individually unless an explicit BEGIN TRANSACTION statement is executed to start a transaction. In chained mode (CHAINED = ON) a transaction is implicitly started before any data retrieval or modification statement.