Creating a Basic Query

Using GUIDE in SQL Mode › Planning the Query › Creating a Basic Query

Creating a Basic Query

The following chart shows the steps involved in creating a query with the GUIDE function on the Main Menu. It provides an overview of the steps outlined in the next section.

Step	Action	Description
1	Invoke GUIDE	See Step 1: Invoke GUIDED QUERY CREATION.
2	Preselect input panels	Mark the things you want your query to do. See Step 2: Decide Which Panels to Use.
3	Identify the query	Give the query a name, status, and optional description. See Step 3: Identify and Save the Query for details.
4	Complete the input panels as they appear	See the remainder of this chapter for procedures. See the CA Dataquery Reference Guide for details on each panel.
5	Execute the query	Complete the ONLINE EXECUTION panel. Define the report you want if you choose to change the defaults defined by GUIDE. Then execute the query. See the remainder of this chapter for training. See Getting a Report and Executing Online for more details.