Getting a Report

DQL Mode and SQL Mode handle report formatting differently. When you use DQL to write a query, you include formatting commands in the query syntax. Reformatting options are available on the ONLINE EXECUTION panel or on the OUTPUT panel. With SQL syntax, the primary focus is on obtaining the data. Therefore, CA Dataquery provides a series of panels in SQL Mode that permit you to vary the format of a report.

Procedure

You must execute a query or dialog to get output. Approach execution from one of three ways:

Select a query or dialog from a directory.
Issue a command (EXECUTE or SUBMIT).
Press a PF key while viewing the EDITOR panel.

After identifying the query or dialog to be processed, execute it using the online or batch method.

Online execution means the execution takes place while you are signed on. Batch execution means a job is submitted with JCL instructions and the processing takes place outside of the current operation of CA Dataquery. Batch results do not print on the terminal screen.