SET LOCK MODE TO WAIT ?

> > > 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. I've > been digging through the documentation and can find nothing to support > his claim. If true it would be a godsend for handling potential > permanent lockups. > > 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? > My 4gl 4.0 manual on page 7-223 documents SET LOCK MODE TO [NOT] WAIT. It gives no indication of a time you can set it to. I would imagine that this is an engine level command and not restricted to the front end tool. I would also imagine that the default amount of time to wait would be that which was set up for the engine when it was initialized under 'Deadlock Timeout' under the Shared Memory parameters. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ Discover America, get lost on a rally. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________