Re: Problem with Set Lock MoDe TO WAIT AND STORED PROCEDURES

I tried that too but still what was happening is that the lock mode is getting set to Not Wait. I am looking for an method to fix this issue. I have tried to put set lock mode to wait in every procedure. I have tried to set the lock mode to wait 300. set lock mode to wait. both of these fail. Thanks Ramesh Paul Watson <P.Watson@LIV001.dss.gov.uk> wrote in article <358E2E0B.343E1417@LIV001.dss.gov.uk>... > RAMESH RAMAMURTHY wrote: > > > Hi, > > I am Facing a problem with Set lock mode to wait and cursory procedure. > > What happens is that informix internally sets the lock mode to NOTWAIT. > > This happens in Version 7.23UC3. Is there way round this problem. INFORMIX > > has been very rude with regard to this trouble and has refused to fix this > > problem inspite of agreeing that this is a problem. > > Thanks in advance > > Ramesh > > You've probably check but have you tried set lock mode to wait <definite > time>. This sounds very like a problem in 7.12. - Lock mode to wait was > ignored but lock mode to wait <time> worked > > -- > Paul Watson # > WF Software Ltd # I don't suffer from stress - > Tel: +44 1436 674729 # I'm a carrier. > Fax: +44 1436 678693 # > www.wfsoftware.co.uk # > > >