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

Selecting GUIDE Panels

Select GUIDE from the Main Menu to create a query with the GUIDE function. CA Dataquery presents this panel so you can preselect components for your query.

The tutorial in the following section shows you how to make selections from this panel and how to make a typical query with GUIDE.

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

With this panel, you can choose to display GUIDE panels that:

• Create the simplest possible query.
• Add one or more query components to the basic version.
• Display every GUIDE panel.

The next sections describe these three levels of GUIDE use.