GUIDE

Conceptual operation of GUIDE remains the same. You select the query objectives at the beginning and complete panels that allow CA Dataquery to construct the syntax.

Since syntax differs in each mode, panels are somewhat different. See the CA Dataquery Reference Guide for details on panel use.

CREATE Function

Both DQL Mode and SQL Mode CREATE functions operate in the same way.

The syntax template panels are different. The template in DQL Mode shows the syntax for DQL, and the template in SQL Mode shows the syntax for SQL.

Syntax

Both modes provide a query language that accesses database data, can manipulate it, and presents it in a report form.

The keywords for the two languages are different and have somewhat different functions.

Online Execution

Both modes provide for online execution and use similar panels to accomplish it.

SQL Mode allows re-execution only at selection or reporting. Although the DQL Mode totaling option panels are not used, SQL Mode adds to online execution the ability to reformat a report (control breaks, titles, and so forth) for the current execution. Totals-only and No-totals are available with a PF key.

Reports

Both modes allow you to define the report format for a query when you create the query. Both modes also allow you to change the report format of any query in the library.

In DQL Mode, the report format is defined using a combination of syntax and execution options. To change parts of the format, you copy and edit the query and execute the new query and save it in the query library. (The query format for the report is not saved in the query library unless the query is saved. Otherwise it will be built and used only for the active query.)

In SQL Mode, the report format is defined on panels accessed during display of the ONLINE EXECUTION panel for the query in question. To change the format, display and change the reporting panels at execution time.