Set Explain On

Marce · #1 (**permalink**) 04-20-04, 15:58

Hi!

I want to run a query with a set explain on and I get the following error:

[Informix][Universal Server][simp_d] SQL Error (-534) : Cannot open EXPLAIN output file.

But I'm running it from the server using dbaccess logged with the user informix .
What's the problem?

lloydnwo · #2 (**permalink**) 04-20-04, 23:39

Quote:

Originally posted by Marce
Hi!

I want to run a query with a set explain on and I get the following error:

[Informix][Universal Server][simp_d] SQL Error (-534) : Cannot open EXPLAIN output file.

But I'm running it from the server using dbaccess logged with the user informix .
What's the problem?

Hi Marce,

The problem could be with lack of write permissions in the current directory. Why don't you login as a normal user & execute the command.

Regards,

Lloyd

Marce · #3 (**permalink**) 04-21-04, 09:48

Lloyd,
I tried using sql editor with another user that it's the pc administrator but it didn't work.
What should I check?
I running informix on windows server 2000.

thanks, Marce

lloydnwo · #4 (**permalink**) 04-22-04, 04:06

Quote:

Originally posted by Marce
Lloyd,
I tried using sql editor with another user that it's the pc administrator but it didn't work.
What should I check?
I running informix on windows server 2000.

thanks, Marce

Hi,

Under your informix directory there should be one directory
sqexpln. Under this the sqlplan will be stored.

Regards,

lloyd