Re: Set Explain Error Message

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