Oninit cdi / Archive
Talk to an expert →

ACE Reports: running into record locks

Posted in 2000

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

R Smith — — source: Informix-list mailing list archive (1991-1998)

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 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

↪ replying to R Smith
Olmedo Monteverde — — source: Informix-list mailing list archive (1991-1998)

There is no way to include the "set lock mode to wait" statement into an ace report. If your associate has the i4gl licence, he could convert the ace report into an 4gl program, where you can handle that statement. Hope it helps, OM <RSmith (R Smith)> a 'crit dans le message : 8EE4B9020rsmithexpressnetcom@204.181.81.99... > 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 > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

↪ replying to R Smith
Steven Wilcoxon — — source: Informix-list mailing list archive (1991-1998)

There is a hidden environment variable SACEISOL that can be set to "dirty read" to allow isolation to be set to dirty read. There is a similar one for perform called SPERISOL. S.W. <RSmith (R Smith)> wrote in message news:8EE4B9020rsmithexpressnetcom@204.181.81.99... > 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 > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Glossary