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 LOCK MODE statementUse the SET LOCK MODE statement to define how the database server handles a process that tries to access a locked row or table.
WAIT Clause
Complete-Connection Level Settings

Complete-Connection Level Settings

The SET LOCK MODE 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 lock mode setting within a transaction, the new value is propagated back to the local environment and also to all subsequent new or resumed transactions.

In releases of HCL OneDB™ earlier than 9.40.UC8, the SET LOCK MODE statement did not support complete-connection level settings. The process waited for the specified number of seconds only if you acquired locks within the current database server and a remote database server within the same transaction.