The Simplest Query

Using GUIDE in SQL Mode › Planning the Query › Selecting GUIDE Panels › The Simplest Query

The Simplest Query

To create a simple query with Guide, select GUIDE from the Main Menu and do not make a selection on the GUIDED QUERY CREATION: OPTION SELECTION panel. Simply press <PF4> CONTINUE.

For information about the panels that appear for these components, turn to Creating a Sample. The following list describes the query creation tasks you complete for a simple query.

Identify the new query.
Select one table for data selection.
Select columns for output.
Specify order of columns and select mathematical functions (if any).

CA Dataquery creates a default report for you. You can format your own report at execution time if you choose not to use the defaults. See Getting a Report for details.