Using GUIDE in DQL Mode › Selecting Guide Panels

Selecting Guide Panels

When you select GUIDE from the Main Menu, you begin to create a query with the GUIDE function. CA Dataquery presents the GUIDED QUERY CREATION: OPTION SELECTION (DQHV0) panel which you use to preselect components for your query.

 =>
 --------------------------------------------------------------------------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

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 following sections describe these three levels of Guide use.