Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SET ISOLATION statementUse the SET ISOLATION statement to define the degree of concurrency among processes that attempt to access the same rows simultaneously.
Complete-Connection Level Settings

Complete-Connection Level Settings

The SET ISOLATION statement supports complete-connection level settings. This means that values in the local session environment at the time of connection are propagated to all new or resumed transactions. These can include the following types of transactions:

transactions within the local database,
distributed transactions across databases of the same server instance,
distributed transactions across databases of two or more database server instances,
global transactions with XA-compliant data sources that are registered in the local database.

If you change the isolation level within a transaction, the new value is propagated back to the local environment and also to all subsequent new or resumed transactions.