Re: SET LOCK MODE TO WAIT ?

On Jul 13, 11:40am, J. David Schronce wrote: } Subject: 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? } } Thanks! } }-- End of excerpt from J. David Schronce This is true for all version of Online but not, of course, for SE. It has existed, as far as I can remember, since the first introduction of Turbo and has always been documented against the Set lock mode to wait command in the SQL syntax manuals. Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!