=> Press <PF4> if you do not wish to define any temporary results --------------------------------------------------------------------------DQH90 DATAQUERY: DEFINE TEMPORARY RESULTS QUERY NAME: _______________ ------------------------------------------------------------------------------- Enter the names of any temporary results you want calculated during query execution. You can also specify the number of digits before and after the decimal point (the precision) of each result. The default is (13.2). ------------------------------------------------------------------------------- RESULT NAME |PRECISION(N.D) ------------------------------------------------------------------------------- | | | | | | | | | | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> NOT USED <PF6> DISPLAY QUERY <PF7> NOT USED <PF8> NOT USED
Description
In DQL Mode, the optional Guided Query Define Temporary Results panel lets you name and define a length for as many as ten columns you want to create for your report that are not contained in the tables you selected.
You set up new columns when you want to know the results of calculating the contents of columns that do exist on the database. An introduction to this panel appears in the CA Dataquery User Guide.
Action
Enter a name for each new result you want to create and use the default precision or define a new precision, if known. Press Enter or <PF4> CONTINUE to go on to the next panel.
Display Fields
Refer to the following chart for explanations of the display fields intended to contain variable data.
Name you assigned this query.
Columns
Refer to the following for a discussion of each column on this panel.
Enter a 1- to 32-character name for a temporary that you want to create to contain the result of a calculation you will define on a later panel.
Enter nothing to accept the default of 13 positions before the decimal point and two decimal positions (13.2) or enter the number of positions the result should have before and after the decimal point. For example, enter 6.3 to specify a result with six numbers and three decimal positions. N + D must be less than or equal to 18.
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.
Returns to Selection Criteria: Designate Columns (DQH60) panel.
Displays the next Guided Query panel when this one is complete.
Displays the query created so far.
|
Copyright © 2014 CA.
All rights reserved.
|
|