Creating, saving, and running queries

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

Learn how to create, save, and run queries.

Procedure

  1. Log in to the web console and go to Query editor.
  2. Specify the name of the query.
  3. Specify the database that you want to use.
  4. Specify the schema that you want to use.
    If you do not pick a schema, the default schema of the database is selected.
    This option appears only for systems that support multiple schemas in a database.
  5. Specify the SQL query that you want to run on the system.
  6. If your query is a select statement, set limit to specify how many rows of data you want to retrieve.
    The default is No limit.
  7. When you input the information, you can do one of the following:
    • Click Run to run the query.

      The result is displayed on the page.

    • Click Run in background to submit the query to the server, and run it in the background.

      The result is not displayed on the page.

    • Click the diskette icon next to the Query name field to save the query as a template.

      The saved query is added to Queries > Recent queries.

    • Click Clear to clear the query.
    • Click Back to go back to previous page.
    Tip: To format your query, click the first icon next to the Query name field.