RE: Set explain problem
}>From informix-list-owner@rmy.emory.edu Wed Nov 6 14:04:22 1996
}>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (940816.SGI.8.6.9/930416.SGI.AUTO)
}> for <settler@dbintellect.com> id OAA28254; Wed, 6 Nov 1996 14:04:20 -0700
}>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id QAA08940 for settler@dbintellect.com; Wed, 6 Nov 1996 16:04:48 -0500 (EST)
}>From: Phuoc Ho <ax205@freenet.carleton.ca>
}>Message-Id: <3280BB85.46B2@freenet.carleton.ca>
}>Subject: Set explain problem
}>Date: Wed, 06 Nov 1996 11:23:33 -0500
}>Reply-To: Phuoc Ho <ax205@freenet.carleton.ca>
}>Organization: Bell Northern Research
}>Sender: informix-list-owner@rmy.emory.edu
}>To: informix-list@rmy.emory.edu
}>X-Informix-List-To: settler@dbintellect.com
}>X-Informix-List-Id: <news.30152>
}>
}>HI ALL,
}>
}>We are running 7.13uc3 on unix 10.10. It seems that the only
}>user that can use set explain without a permission error (534)
}>is informix. I contacted Informix Support and get the
}>answer that I always get: UPGRADE! Anyone running into
}>the same problem? Any work-arounds will be greatly appriciated.
}>
}>Thanks in advance!
}>
}>PS: I am running set explain on the same machine as the server.
}>
I have the opposite problem with 7.12.uc3 on IRIX 5.3 - informix
is the only one who gets the permission error. You might try
shelling out to the c shell before using SET EXPLAIN - this worked
for us. For example:
/usr/people/kornshell/me>csh
hostname% dbaccess dbname
When I use SET EXPLAIN in this dbaccess session invoked from a
c shell, I don't get the error.
-------------------------------------------------------------------
Jeff Craig | dbINTELLECT Technologies, Inc.
Senior Consultant | Golden, CO
| (303) 275-6954 ext. 8008
| email: settler@dbintellect.com
| fax: (303) 275-2134
-------------------------------------------------------------------