=> --------------------------------------------------------------------------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 can 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
Description
This panel appears after you select GUIDE from the Main Menu or issue the GUIDE command. It allows you to specify the type of query you want to create. The specifications you enter determine which panels appear during Guided Query operation.
Action
To create the simplest query, make no entries and press <PF4> CONTINUE. To add features to the query, enter a character in the field preceding one or more options and press <PF4> CONTINUE.
Select
Refer to the following for explanations of the selections available on this panel.
Sort report data.
Request specific rows to be selected.
Create data for the report by requesting calculations to be made.
Join two tables for data selection.
PF Keys
The following lists the PF keys for this panel, with a brief description of each function.
Displays Help information about the current panel.
Exits the current panel.
Displays first Guided Query input panel.
|
Copyright © 2014 CA.
All rights reserved.
|
|