Re: Set Explain Error Message

Posted in 1996

dstafford@krames.com — 18 Jun 1996 02:05:53 GMT — source: Informix-list mailing list archive (1991-1998)

> jschumac@uns-dv7 (Joel Schumacher) writes: > Justin Farmiloe (justin.farmiloe@bellsouth.co.nz) wrote: > : 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 > Another possibility is that Informix may need to use some temp space. Is the DBTEMP environment variable correctly set?