Re: ACE Reports: running into record locks

There is an environmnetal variable, SACEISOL, that you can set that should help you. There is a corresponding isolation setting for perform screens, as well: export SPERISOL="dirty read" export SACEISOL="dirty read" RSmith wrote > One of my associates has chosen ACE as his reporting tool and > has written several reports. Many times they execute no problem, > other times they bomb when encountering a record lock. > > I believe that Informix opens the db in NO WAIT mode. > > In esqlc, I include the statement "EXEC SQL SET LOCK MODE TO WAIT 30", > but I don't see any options for the ACE reports. > > Any suggestions? > > Thank you. > > R Smith -- Colin