=> --------------------------------------------------------------------------DQI80 DATAQUERY: SEARCH CONDITIONS: MULTIPLE CONDITIONS QUERY NAME: _______________ ------------------------------------------------------------------------------- Below are the conditions you defined to qualify rows selected from the database. Use the logical operators "AND", "OR", "(", and ")" to logically group your conditions. The default statement appears below. You can type over it to change it. => ___________________________________________________________________________ ------------------------------------------------------------------------------- NUMBER| COLUMN NAMES/CONDITIONS |COMPARISON OPERATOR(S) AND VALUE(S) ------------------------------------------------------------------------------- | | | | | | | | | | | | | | | | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> NOT USED <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
Description
This SQL Mode Guided Query panel appears when you select more than one column and condition per table for narrowing your query's search for data. You select columns that contain data you want to use in qualifying the search.
When those conditions are defined, this Multiple Conditions panel appears to allow you to group the conditions into a logical expression using AND, OR, and parentheses ( ) and the number assigned to each condition. CA Dataquery always ands each condition sequentially as the default expression.
Action
Type over the default logical expression with your own expression, using the numbers provided for each condition. Or, accept the default statement by pressing <PF4> CONTINUE.
Display Fields
Refer to the following for explanations of the display fields intended to contain variable data.
Name you assigned this query.
Default logical expression created by CA Dataquery to group condition statements.
Entry Field
The following describes how you can use the entry field that contains the default statement.
A default logical expression combining all conditions by adding them together. You can write over this expression to tell CA Dataquery how to apply the qualifying conditions in the search for data.
Columns
Refer to the following chart for a discussion of each column on this panel.
Number CA Dataquery assigned a column and its condition.
Names of columns/conditions selected for qualifying the search for data.
Conditions constructed for each column.
Sample
=> --------------------------------------------------------------------------DQH80 DATAQUERY: SELECTION CRITERIA:MULTIPLE CONDITIONS QUERY NAME: MULTI-2 ------------------------------------------------------------------------------- Below are the conditions you defined to qualify rows selected from table CAI-RCPTS-REC . Use the logical operators "AND", "OR", "(", and ")" to logically group your conditions. The default statement appears below. You can type over it to change it. => (2 and 3) or (1 and 4) ------------------------------------------------------------------------------- NUMBER| KEY (*) AND COLUMN NAMES |COMPARISON OPERATOR(S) AND VALUE(S) ------------------------------------------------------------------------------- 01 | RECEIPT-ID | GT 1 02 | REC-QTY | GTE 1 03 | ITM-ID | EQ 999 04 | REC-YR | EQ 86 | | | | | | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> NOT USED <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
The preceding example tells CA Dataquery to retrieve only data from the CAI-RCPTS-REC table rows that contain a REC-QTY greater than or equal to 1 AND an ITM-ID equal to 999 OR rows that contain a RECEIPT-ID greater than 1 AND a REC-YR equal to 86.
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.
Goes to the next Guided Query Creation step.
Displays the query created so far.
Scrolls to the previous panel, if any.
Scrolls to the next panel, if any.
|
Copyright © 2014 CA.
All rights reserved.
|
|