Contents Index BLOCKING_TIMEOUT option [database] CHECKPOINT_TIME option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

CHAINED option [compatibility]


Function 

Controls transaction mode in the absence of a BEGIN TRANSACTION statement.

Allowed values 

ON, OFF

Default 

ON

OFF for Open Client and JDBC connections

Description 

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.


Contents Index BLOCKING_TIMEOUT option [database] CHECKPOINT_TIME option [database]