Results 1 to 5 of 5

Thread: Set Explain On

  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Red face Unanswered: Set Explain On

    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?

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: Set Explain On

    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

  3. #3
    Join Date
    Mar 2004
    Posts
    18

    Still getting the same error message

    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

  4. #4
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: Still getting the same error message

    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

  5. #5
    Join Date
    Mar 2004
    Posts
    18

    Thumbs up Thanks

    Lloyds,
    Just writing to thank you for the help.
    Sincerely, Marcela

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •