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.

3

Use template panel

Display the DQL 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 Edit SELECT Clause 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.