Basic Query Creation Procedure

Using CREATE in SQL Mode › Planning the Query › Basic Query Creation Procedure

Basic Query Creation Procedure

The following chart shows the steps involved in creating a query with the CREATE function on the Main Menu. It provides an overview of the steps outlined in the next section. As you gain experience, you might decide to vary the order of some steps.

Step	Action	Description
1	Invoke the EDITOR	See Accessing the EDITOR.
2	Identify query	Complete the fields at the top of the panel with a query name, type, status, and description. See Step 2: Identify the Query and be sure to see Restrictions on Names for important restrictions on names.
3	Use template panel	Display the SQL template and select clauses needed for the query to create a customized template. See Step 3: Use the SQL Template for details.
4	Edit the query template you create	Use line commands and keyboard keys to alter template clauses as you create the query. See 1 through Edit ORDER BY Clause for details.
5	Validate	Have CA Dataquery check the query syntax, table names, and column names for accuracy. See Steps 5 and 6: Validate and Save the Query for details.
6	Save the query	Save the query with the name shown so that it can be used again later. (You can also change it later and update your changes, if it becomes necessary.)
7	Execute the query	Complete the ONLINE EXECUTION Panel and define the report you want if you do not want to use the defaults. Then execute the query. See Step 7: Format Report and Execute Query for more information.