Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Programming for a multiuser environment
How locks workHCL® OneDB® database servers support a complex, flexible set of locking features that the topics in this section describe.
Lock scope
Page locks
Set the row or page lock mode for all CREATE TABLE statements
Multiple-user lock mode

Multiple-user lock mode

Database administrators can use the multiple-user lock mode to create greater concurrency by designating the lock mode for all users on the same server. All tables that any user creates on that server will then have the same lock mode. To enable multiple-user lock mode, set the IFX_DEF_TABLE_LOCKMODE environment variable before starting the database server or set the DEF_TABLES_LOCKMODE configuration parameter.