Re: "LOCK MODE TO WAIT" seemingly ignored

Mark Stevans wrote: > > Hi. I'm programming in ESQL/C on Solaris for Informix 7.12. After my > "CONNECT" statement, I issue the statement "SET LOCK MODE TO WAIT", and > then my app does lots of "INSERT" operations. No problem when I run the > app alone. > > But when I try to run multiple copies of my app concurrently, once in a > while the "INSERT" fails, returning SQLSTATE "IX000", SQLCODE -271 > within a second of real time of when the "INSERT" was initiated. The > exception messages fetched are "Could not insert new row into the table" > and "ISAM error: key value locked". > [cutting] Try setting the WAIT to a definite time. I had the same problem with Gupta and 7.12. Setting it the WAIT TO 5 (or whatever) solved it. -- Paul Watson # WF Software Ltd # It said run using Windows 95 Tel: +44 1436 674629 # or better in the manual Fax: +44 1436 678693 # so I used Unix www.wfsoftware.co.uk #