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
Lock with the SELECT statementThe type and duration of locks that the database server places depend on the isolation set in the application and whether the SELECT statement is within an update cursor.

Lock with the SELECT statement

The type and duration of locks that the database server places depend on the isolation set in the application and whether the SELECT statement is within an update cursor.

This section describes the different isolation levels and update cursors.