Execute a query

Queries are executed in background and you can execute other queries while waiting for the results. In the history panel, the query icon shows that the query is in progress. While the query execution is in progress, the same user cannot execute it again until the results are displayed. However, another user can execute the query if it is not shared.

  1. Execute the query from the main screen:
    Select queryTo display results in

    Right click query in list and select :

    • Execute
    • Execute in panel 2
    P1 or P2
    Double click query in query tree of navigator paneP1 by default
    From P1/P2 header comboThe panel that contains the combo box
  2. If some of the arguments or values are missing, the Query Wizard prompts you to:
    • Enter the required values.
    • Click OK.
  3. If your query requests records that are located in a partition that has been archived or purged, your query is rejected and a warning message is displayed.
    • A dialog window displays the list of the partitions that are needed for the query.
    • You can copy this list to the clipboard and send it to your administrator for him to mount the corresponding partitions.
  4. When the execution has ended, the results are displayed in the selected result panel if they are available right away.
    However if it is a long duration query, a notification is displayed and a link provided to access the execution results.

Related Links