Using CREATE in SQL Mode › Writing a Sample SQL Query › Creating the Sample Query › Step 7: Format Report and Execute Query

Step 7: Format Report and Execute Query

The Process Mode PF key menu provides a PF key for executing a query. We recommend that you execute new queries and check the results. You might decide to alter and update the saved query. Execution instructions appear in Executing in SQL Mode.

SQL Mode execution allows you to provide specifications about the report you want to produce at execution time. These specifications are:

• Title
• Columnar or List presentation
• Sorting sequence of ORDER BY columns and control breaks for ORDER BY columns
• Starting a new page
• Column order
• Mathematical functions AVG, MAX, MIN, SUM, CNT, and TOT
• Legends for function results
• Edit patterns of function results
• Two-line column names

To use control breaks and sorting with report format specifications during execution, the query must contain an ORDER BY clause so that rows are retrieved in sorted order.

You can set the defaults for these specifications for a query you create. The Execution panel provides an optional set of panels that any user with access to your query can use to specify report specifications. When you execute a saved query for the first time and enter the specifications, they are saved and become the defaults. If you do not enter any specifications, CA Dataquery sets the defaults.

For details and information about defining a report created from an SQL query, see Getting a Report. Follow directions there for completing the report definition panels. When you execute the query the first time, the specifications are saved.