Using GUIDE in SQL Mode › Creating a Sample Query › Sample Procedure › Step 2: Decide Which Panels to Use

Step 2: Decide Which Panels to Use

This section tells you what the GUIDE options are and how to choose them. It also shows you how to complete this step as you resolve the sample business problem.

To Start

After you select GUIDE from the Main Menu, the following panel appears:

GUIDED QUERY CREATION: OPTION SELECTION (DQHV0)

 =>

 --------------------------------------------------------------------------DQHV0
 DATAQUERY:   GUIDED QUERY CREATION:  OPTION SELECTION
 -------------------------------------------------------------------------------
 When you create a query with Guided Query, a basic query will be generated as
 the default.  You may override this default and customize your query by
 selecting one or more of the extended options listed below.

 To create a basic query that selects all rows from a single table, presenting
 the selected rows in a random sequence, press <PF4>.

 To select options to add to the basic query, place any character beside the
 options of your choice and press <PF4>.

    _  Specify the order in which the retrieved information will be presented

    _  Limit the output report size by specifying selection criteria

    _  Create your own columns for the output report

    _  Retrieve and combine information from two tables
 -------------------------------------------------------------------------------
 <PF1> HELP         <PF2> RETURN       <PF3> NOT USED       <PF4>  CONTINUE

Facts

The following describes what each selection enables you to do.

Create a basic query...

Select one table and one or more columns to produce a report. Perform mathematical functions on one or more columns, if needed.

Specify order....

Determine the sorting order for report data.

Limit report size...

Define criteria the data must meet to be selected.

Create your own report columns...

Create data for the report that is a result of an arithmetic expression or that is a literal value.

Retrieve information from two tables...

Specify two tables for data selection and establish conditions for joining them.

When you need to create queries that perform these functions, make the appropriate selections and use the CA Dataquery Reference Guide to look up the required entries for each panel that appears.

Action

To make selections for the sample, enter an X in the fields for selecting panels that allow you to specify the order of report data and to create your own report columns. Press <PF4> CONTINUE.

Options

Select any or all of the available options.