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
Set the lock mode
Limited time wait

Limited time wait

You can ask the database server to set an upper limit on a wait with the following statement:

SET LOCK MODE TO WAIT 17

This statement places an upper limit of 17 seconds on the length of any wait. If a lock is not removed in that time, the error code is returned.