Using GUIDE in SQL Mode › Creating a Sample Query

Creating a Sample Query

Use this section to gain a basic understanding of how the GUIDE function works. When you finish, you will understand how to create a basic query with GUIDE and you will also know some fundamental facts about CA Dataquery.

This section presents a sample objective, the report needed to accomplish the objective, and the GUIDE panels that appear when a basic query is selected from the GUIDED QUERY CREATION: OPTION SELECTION (DQHV0) panel. Along with a discussion of the procedures involved in creating a query with Guide, we present basic concepts where they are relevant to the discussion of a panel.

You can follow the tutorial and create your own query. Simply choose a table on your database that has both character and numeric data and follow the directions on the next pages (using the correct names for your data).