Panels › (DQI70) Search Conditions: Define Condition

(DQI70) Search Conditions: Define Condition

 =>
 
 --------------------------------------------------------------------------DQI70
 DATAQUERY: SEARCH CONDITIONS: DEFINE CONDITION     QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Define the condition by selecting a comparison operator and a value to compare
 with  ________________________________  in  ________________________________
 
 Select one comparison operator:
 
 _ Equal     ( =  )    _ Greater than ( > )    _ Greater than or equal ( >= )
 _ Not equal ( ,= )    _ Less than    ( < )    _ Less than or equal    ( <= )
 _ Like                _ Not like
 
 Enter value for comparison with ________________________________
 
 _______________________________________________________________________________
 _______________________________________________________________________________
 _______________________________________________________________________________
 _______________________________________________________________________________
 
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2> RETURN         <PF3> REPEAT COLUMN <PF4> CONTINUE
 <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY  <PF7> NOT USED      <PF8> NOT USED

Description

The SQL Mode Guided Query optional Search Conditions: Define Condition panel appears for every column selected as a Selection Criteria column in the previous step. With it, you describe the data you want to be searched for in a column to qualify a row for inclusion in your report.

Action

Choose a comparison operator from the panel by entering a character next to the one that indicates how you want to compare the found column values to the values you enter at the bottom of the panel. You can choose only one operator.

Your entries on the blank lines provided must follow the rules for specifying comparisons in SQL as documented in SQL Statements or the CA Datacom/DB SQL User Guide. When the panel is complete and correct, press Enter or <PF4> CONTINUE to go to the next step.

Display Fields

Refer to the following for explanations of the display fields intended to contain variable data.

QUERY NAME:

The name you assigned this query.

compare with ___

The column selected for comparison of the values you will enter on this panel.

in ___

The name of the table containing the selected column.

Select

Make selections on this panel according to the following.

Equal

Data in the column must be equal to the value you enter below for the row to be selected.

Greater than

Data in the column must be greater than the value you enter below for the row to be selected.

Less than

Data in the column named must be less than the value you enter below for the row to be selected.

Not equal

Data in the column named must not match the value you enter below for the row to be selected.

Greater than or equal

Data in the column must be greater than or equal to the value you enter below for the row to be selected.

Less than or equal

Data in the column named must be less than or equal to the value you enter below for the row to be selected.

Entering Comparison Values

On the lines following "Enter value for comparison with _," enter any valid comparison value, following the rules for specifying comparisons in SQL Statements or the CA Datacom/DB SQL User Guide.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Returns to the Search Conditions: Designate Columns (DQH60) panel.

<PF3> REPEAT COLUMN

Lets you use the same column again in another comparison.

<PF4> CONTINUE

Displays the next Guided Query panel when this one is complete.

<PF5> EXTEND COLUMN

Displays the extended column definition for key or column.

<PF6> DISPLAY QUERY

Displays the query created so far.