Re: SET EXPLAIN: Error -534

WHAT ARE THE PERMISSIONS ON YOUR INFORMIX BINARIES???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? From: R Srinivasan <euroinvestor@yahoo.com> > >-Current directory has "drwxrwxrwx" permissions. So I don't think that >would be the problem. Also, this used to work. >-And I don't remember changing anything. Haven't messed with >permissions on the Informix binaries. >-I don't have a temp dbspace set, as someone suggested. So I guess I'll >have to try that. >- I also tried a) removing sqexplain.out and b) creating a zero-length >file with "-rwxrwxrwx" permissions. >-SET EXPLAIN does work when I'm user 'informix', though. > >Sorry about cramming all my replies here. I use deja.com from work and >I don't have the news reader interface that sorts message threads. >Every reply seems to be a new post in deja, although one can view the >threads with a link. > >In article <8neada$suj$1@nnrp1.deja.com>, > mars1972@my-deja.com wrote: > > current directory. > > > > In article <ph9L8eA3Oqm5EwK1@kontron.demon.co.uk>, > > Andy Lennard <andy@kontron.demon.co.uk> wrote: > > > I can't remember where 'sqexplain.out' goes to. Is it users current >or > > > home directory... > > > > > > Perhaps one already exists in whatever directory, but it was created > > by > > > someone else, so it won't let you append to it. > > > > > > kick off: > > > > > > find / -name sqexplain.out -ls > > > > > > and delete whichever ones it finds in the hope that this will >resolve > > > the problem! > > > > > > Good luck. > > > > > > In article <8ne3di$k47$1@nnrp1.deja.com>, euroinvestor@yahoo.com > > writes > > > >Yes I do have permission to create files in the current directory. > > > > > > > >In article <8ndnuf$duf$1@news.xmission.com>, > > > > "Watson, Paul" <Paul.Watson@aggregate.com> wrote: > > > >> > > > >> You don't have permission to create the file where you are. > > > >> > > > >> Paul Watson > > > >> WF Software Ltd > > > >> Tel: +44 1436 674729 > > > >> Fax: +44 1436 678693 > > > >> www.wfsoftware.com/informix > > > >> > > > >> > -----Original Message----- > > > >> > From: euroinvestor@yahoo.com [mailto:euroinvestor@yahoo.com] > > > >> > Sent: Wednesday, August 16, 2000 05:09 > > > >> > To: informix-list@iiug.org > > > >> > Subject: SET EXPLAIN: Error -534 > > > >> > > > > >> > > > > >> > IDS 7.30.UC2 > > > >> > D4GL v 3.00 > > > >> > > > > >> > I have the following program: > > > >> > > > > >> > ###### > > > >> > database mydb > > > >> > main > > > >> > set explain on > > > >> > end main> > > >> > ###### > > > >> > > > > >> > Running this program yields the following error: > > > >> > ###### > > > >> > Program stopped at 'x.4gl', line number 6. > > > >> > SQL statement error number -534. > > > >> > Cannot open EXPLAIN output file. > > > >> > SYSTEM error number -1. > > > >> > Not owner > > > >> > ###### > > > >> > > > > >> > I get the same error when trying to run "SET EXPLAIN" from > > dbaccess. > > > >> > Never had this problem before. If I something has changed, I am > > not > > > >> > aware of it. I also have an instance of IDS 7.23.UC1 and it >works > > > >ok. > > > >> > > > > >> > Any pointers/help is appreciated. Thanks for your time. > > > >> > > > > >> > > > > >> > Sent via Deja.com http://www.deja.com/ > > > >> > Before you buy. > > > >> > > > > >> > > > > > > > > > > > >Sent via Deja.com http://www.deja.com/ > > > >Before you buy. > > > > > > Andrew Lennard > > andy@kontron.demon.co.uk > > > > > > > -- > > # unrm / > > ksh: unrm: not found > > # man cpio > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com