Re: Upgrade to 7.3

In article <6vtkgi$gig$1@lilly.ping.de>, "Dirk Schnorpfeil" <schnorpf@cyberworld.ping.de> wrote: > Someone wrote: > > >>1) any 4gl with an update subquery within a cursor does not work. the > >>update doesn't happen. But it does work within dbaccess. The fix is an > >>environment variable NO_SUBQF. Make sure you bounce your instance with > that > >>env sourced. The problem is with the changes they made to the optimizer, > how > >>it "flattens" subqueries. We put it in /etc/profile. > >> > > Very interesting, we got the same problem with one of our customers. Well, > to what value should i set "NO_SUBQF" ??? set NO_SUBQF=1. just to reiterate, once you set the variable, bounce database instance. > > Ciao, Dirk. > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own