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
Simple concurrency

Simple concurrency

If you are not sure which choice to make concerning locking and concurrency, you can use the following guideline: If your application accesses non-static tables, and there is no risk of deadlock, have your program execute the following statements when it starts up (immediately after the first CONNECT or DATABASE statement):

SET LOCK MODE TO WAIT
SET ISOLATION TO REPEATABLE READ

Ignore the return codes from both statements. Proceed as if no other programs exist. If no performance problems arise, you do not need to read this section again.