Re: SET LOCK MODE TO WAIT ?

Posted in 1995

Dority — 15 Jul 1995 10:59:20 -0400 — source: Informix-list mailing list archive (1991-1998)

>Subject: SET LOCK MODE TO WAIT ? >From: david@cssnet.sanford.nc.us (J. David Schronce) >Date: Thu, 13 Jul 95 11:40:38 EDT >Message-ID: <FeP78c1w165w@cssnet.sanford.nc.us> >In a recent mail exchange with another Informix programmer, he mentioned >that it was possible to use "SET LOCK MODE TO WAIT 60" and have the >system time out after the table was unavailable for 60 seconds. >Can anyone confirm or deny that a wait period can be specified as a >parameter to SET LOCK MODE TO WAIT and if so, what is the default? Its true, Informix OnLine does have such a command. It is documented too. The default is NO WAIT - OnLine will not wait at all when it detects a lock. Have fun...