The SET LOCK MODE statement supports complete-connection level settings. This means that values in the local session environment at the time of connection are propagated to all new or resumed transactions. These can include the following types of transactions:
If you change the lock mode setting within a transaction, the new value is propagated back to the local environment and also to all subsequent new or resumed transactions.
Releases of Dynamic Server earlier than 9.40.UC8, the SET LOCK MODE statement did not support complete-connection level settings. The process waited for the specified number of seconds only if you acquired locks within the current database server and a remote database server within the same transaction.
Related statements: LOCK TABLE, SET ISOLATION, SET TRANSACTION , and UNLOCK TABLE
For a description of the two distinct meanings of the term lock mode in this manual, see the section Locking Granularity.
For a discussion of how to set the lock mode behavior of the database server, see the IBM Informix Guide to SQL: Tutorial.