Re: Informix Sysprocplan error

In article <6r9c58$cfa$1@news.xmission.com>, craiglanford@yahoo.com (Craig Lanford) wrote: > > Ezequiel, > > Set lock mode to wait will allow a thread to go to a wait state until> it can acquire a the lock it is requesting. This can be good and bad > depending on how long the thread has to wait. Unfortunately, Informix > has identified a bug with all IDS 7.2 and 7.3 where set lock mode to > wait does not work this way in a stored procedure. The thread will > wait on the first resource in a wait state and then the engine will > change the lock mode state to the default which is no wait. This is > causing us problems in which we are forced to redesign our application > because we cannot seem to get a bug fix for this. > > Craig Lanford > Mailto:craiglanford@yahoo.com > Have you tried set lock mode to wait <definite period> as opposed to set lock to wait. There were problems in some of the 7.1x release with set lock mode to wait, but if you specified a time it was OK. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #