Justin Farmiloe (justin.farmiloe@bellsouth.co.nz) wrote:
: I am hoping someone can help me with this error:
: When I am logged in as informix, I can run the SQL command SET EXPLAIN
: ON fine. When I am logged in as a standard user, and I try it, I get
: the following:
: > set explain on;
: >
: 534: Cannot open EXPLAIN output file.
: 130: ISAM error: no such DBspace
: Error in line 1
: Near character position 14
: I can't figure out what is wrong with the environment, nor why the
: EXPLAIN function is needing a specific dbspace. I am using SQL 6.01.UD1,
: OnLine 7.11.UC1
: Any help appreciated.
Explain usually writes to the directory you're in. Make sure you have
write permission on that directory.
Is the database you're trying to connect to on a different machine? I've
seen sqexplain.out get created in the informix directory of the remote
machine. In which case, me as myself didn't have permission to write to
the informix directory, but user informix did. As myself, I got the -534
SQLCODE, but a 0 for the ISAM code.
I wouldn't put too much faith in ISAM codes. They are sometimes very
confusing and sometimes seem totally unrelated. After you figure out
the problem, you say "Yeah, I can see how that kinda fits in a vague
sort of way".
Have you got a database open already when you execute the explain
statement? Or do you do an explain statement first?
__________________________________________________________________________
Joel Schumacher JCPenney Co. - UNIX Network Systems
jschumac@uns-dv1.jcpenney.com 12700 Park Central Pl
(214) 591-7543 Dallas TX 75251