Getting a Report › Using SQL Mode Reporting

Using SQL Mode Reporting

When you create a query, SQL Mode execution allows you to provide specifications about the default report you want to produce at execution time. If you do not want to define a default report, CA Dataquery creates one automatically. If you are executing someone else's query or dialog, you can change the specifications, depending on what you want in your report.

Options

You can add the following features:

• Overall appearance:
  • Title
  • Columnar or List presentation
  • Report column order
  • Headings for report columns
  • Edit patterns for numeric data
• Extras permitted if the ORDER BY clause is present in query:
  • Sorting sequence of ORDER BY columns
  • Control breaks taken on ORDER BY columns
  • Separate pages for each ORDER BY group of columns
• Mathematical functions
  • Column functions AVG, MAX, MIN, SUM, CNT, and TOT at control breaks or end of report
  • Legends for function results
  • Edit patterns of function results

To report results of mathematical functions for groups of rows, change sort specifications or use page breaks, the query must contain an ORDER BY clause so that rows are retrieved in sorted order.

Description

Enter report specifications on the sequence of panels that appears when you press <PF4> FORMAT REPORT during display of the ONLINE EXECUTION panel (DQE60) or when you use the FORMAT command. Once the query author sets these specifications, they become the default. Others who can access the query can change the specifications for one online execution only.

The specifications cannot be changed during batch execution. To process a query in batch with different report specifications, copy the query and set your own default report. (See Accessing the EDITOR for details on copying queries.)

The remainder of these pages describe the process of setting report specifications.

Note: For more information about each panel, see the CA Dataquery Reference Guide.