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™.
LOCK TABLE statementUse the LOCK TABLE statement to control access to a table by other processes.
Concurrent Access to Tables with Shared Locks

Concurrent Access to Tables with Shared Locks

After the LOCK TABLE statement that specifies the IN SHARE MODE keywords executes successfully, other users can read the table but cannot modify its data until the lock is released. In databases that support transaction logging, the SELECT statement can implicitly place a shared lock on each tables that is listed in the FROM clause, in order to prevent other users from modifying those tables until the query is committed or rolled back.