General Information › What can I do with the Menu Facility?

What can I do with the Menu Facility?

Create reports

You can report on:

• SQL tables
• ASF tables
• Database records

Format your report

You can enhance the appearance of your report by:

• Sorting report rows
• Modifying column and page headers
• Specifying external pictures for columns
• Changing the spacing between columns
• Using code tables to translate data stored in the database into an alternative external representation

Perform computations

You can create the following types of report calculations:

• Computed columns
• Break processing and group subtotals
• Report totals
• Calculations including aggregate and built-in functions

Save a report

Once you create a report, you can save it online for a specified period of time.

Create a table from a report

You can create a table by saving your CA OLQ report as a table. The rows and columns in the table correspond to those you have defined in the report.

Define predefined routines

You can save the set of CA OLQ commands used to create a report in a routine. This routine can be re-executed to create reports that reflect the changing nature of data in the database.

Print a report

You can route your CA OLQ report to output devices defined to your system.

Execute OLQ commands using the OLQ batch facility

You can use the CA OLQ batch facility to create reports that query very large amounts of data, or to execute during non-peak hours.