Create and Open a Query

This topic describes the process of creating and opening queries.

Create a New Query

1. From the Query Designer homepage, click the New Query button. The New Query Information panel appears.



2. In the New Query Information panel, specify a unique name and (optional) description for the query.
   1. Select the appropriate connection from the Select available connection drop-down list.
   2. Click Create. Based on the setup of the connection, either a login or the Add Tables panel appears.
3. If the login panel appears, enter your credentials and click Login. The Add Tables panel appears.

Note: The first time the Add Tables panel is accessed for a connection, the system builds a cache of available tables. The time required to load the tables varies based on the number of tables. When the Add Tables panel is subsequently accessed for the connection, the process will be faster, as the tables are loaded from the cache.

4. Proceed to the next step: Add a Table.

Open an Existing Query

1. From the Query Designer home page, click the Open Query button. The Select Query to Open panel appears, allowing the user to locate a query anywhere in the network. This defaults to the Queries folder location.
2. Select the query, and click Open.