+ New Ticket

Explain window not showing

Comments

6 comments

  • Official comment
    Avatar
    Sergey Polshvedkin

    Hello Omar,

     

    Have you tried applying EXPLAIN to your query and look at the Result tab?

    (there is Output and Result tabs appear after you launch a query in WB) 

     

    Regards,

    Sergey

    Comment actions Permalink
  • Avatar
    Omar Brunt

    Hello,

    thanks for your quick reply. As a matter of fact I do not have or can not find a 'Result' tab, I have only Output.

     

    0
    Comment actions Permalink
  • Avatar
    Sergey Polshvedkin

    Hi Omar,

     

    Could you provide some screenshots to get more details on this?

     

    Regards,

    Sergey

    0
    Comment actions Permalink
  • Avatar
    Omar Brunt

    Yes sure. I tried adding explain and clicking 'Execute';

     

     

    AND

    I removed the 'EXPLAIN' command and clicked the 'Explain' button with the eye on it. Window blinks so that I know the button at least did something, and the state of the application doesn't change a bit;

     

     

    0
    Comment actions Permalink
  • Avatar
    Sergey Polshvedkin

    Hi Omar,

     

    That is interesting.

    Please send us details (see below) to support@aginity.com 

     

    Full system information:

    1. Select from main menu: Help -> System Info... 
    2. When System Information dialog appears, click "Copy to Clipboard" button 

     

    Workbench log file:

    1. Go to Help menu -> Show Log file.
    2. Attach or send us the log (preferably as a .txt).

     

    A version of netezza server you are connected to with query: select version()

    Which driver are you using to connect the netezza server? (connection window in workbench)

     

    p.s.

    just in case could you switch schema from ~SVC-DPL_DWH to one that you are trying to query PONLOGISTICS_SDW and try again

     

     

     

    0
    Comment actions Permalink
  • Avatar
    Omar Brunt

    Sergey suggested to use ODBC instead of OleDB, and lo and behold, that did the trick! Very good, we're able to explain our queries now. Good job.

    0
    Comment actions Permalink

Please sign in to leave a comment.