Row Selection Criteria panel

You use the Row Selection Criteria panel to specify row selection criteria by column.

Panel and field definitions

   Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────
 ────────────────────
 FM/Db2 (DFG2)              Row Selection Criteria                 Line 1 of 14

 Cmd Con ( Column name                         Op  Value                       )
     <-> - <---+----1----+----2----+----3----> <-> <---+----1----+----2----+-- -
 *** ****  Top of data  ****
           EMPNO                                                                
     AND   FIRSTNME                                                             
     AND   MIDINIT                                                              
     AND   LASTNAME                                                             
     AND   WORKDEPT                                                             
     AND   PHONENO                                                              
     AND   HIREDATE                                                             
     AND   JOB                                                                  
     AND   EDLEVEL                                                              
     AND   SEX                                                                  
     AND   BIRTHDATE                                                            
     AND   SALARY                                                               
     AND   BONUS                                                                
     AND   COMM                                                                 
 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F5=RFind     F6=RunTemp
  F7=Up        F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel
Cmd
Prefix command column.
You can use the following prefix commands when editing row selection criteria by column:
A
Identifies the line after which data is to be moved or copied.
B
Identifies the line before which data is to be moved or copied.
C
Copy one line.
Cn
Copy n rows.
CC
Copy block of lines. Mark start and end of block.
D
Delete one line.
Dn
Delete n lines.
DD
Delete block of lines. Mark start and end of block.
M
Move one line.
Mn
Move n lines.
MM
Move block of lines. Mark start and end of the block.
R
Repeat one line.
Rn
Repeat n lines.
RR
Repeat block of lines. Mark start and end of the block.
RRn
Repeat block of lines n times. Mark start and end of block.
Con
Connector column.

You specify the AND and OR connectors in this column. The default value is AND. You can use abbreviations. For example, if you overtype the existing connector, AND, with O, FM/Db2 generates an OR connector.

Connectors are only relevant to lines containing expressions (that is, where you have specified an operator in the Op column).

You can overtype the existing connector with one of the following values:
AND or &
FM/Db2 generates an AND connector in the resultant WHERE clause.
OR or |
FM/Db2 generates an OR connector in the resultant WHERE clause.
(
Left parenthesis column.

If you need to define the sequence of evaluation for the resultant WHERE clause by enclosing part of the clause in parentheses, use this column to type a left parenthesis ("(") at the appropriate point.

You can only use a parenthesis on a line containing expressions (that is, where you have specified an operator in the Op column). The number of left parentheses must match the number of right parentheses.

Column name
The name of the column.

On 80-byte screens, FM/Db2 displays either the column name details (the default) or the data type details for the column. To toggle between FM/Db2 displaying the Column name and Data type(length) details, press the PF11 function key.

Data type(length)
The Db2® data type and, where applicable, length of the column.

On 80-byte screens, FM/Db2 displays either the column name details (the default) or the data type details for the column. To toggle between FM/Db2 displaying the Column name and Data type(length) details, press the PF11 function key.

Op
Operator column. Operators are used to create expressions. When you type an operator in the Op column, it indicates that you want FM/Db2 to form an expression using the column name on that line of the panel, the operator you have specified and, with the exception of the operators NL, ¬NL, and NNL, the contents of the Value column.
FM/Db2 supports the following operators:
= or EQ
True if the terms are equal (numerically, or when padded).
¬= or NE
True if the terms are not equal (inverse of =)
> or GT
Greater than
< or LT
Less than
>= or GE
Greater than or equal to
\= or ¬<
Not less than
<= or LE
Less than or equal
\> or ¬>
Not greater than
LK
LIKE predicate. Column must not be numeric.
¬LK or NLK
NOT LIKE. Column must not be numeric.
BTW
BETWEEN. Value must be in the form value1,value2.
¬BT or NBT
NOT BETWEEN. Value must be in the form value1,value2.
IN
IN. Value must be in the form value1,value2,…
¬IN or NIN
NOT IN. Value must be in the form value1,value2,…
NL
IS NULL. Value must be blank.
¬NL or NNL
IS NOT NULL. Value must be blank.
RG
Range. Value must be in the form value1,value2.
NR
Not in range. Value must be in the form value1,value2.
Value
The character or numeric constant to be used with the specified operator and column name to create an expression in the resultant WHERE clause.

When the operator is NL, ¬NL, or NNL, the Value column must be blank. For all other operators, the Value column must not be blank

For operators that support more than one value (BTW, ¬BT, NBT, IN, ¬IN, NIN, RG, or NR), the values must be separated by commas. For operators IN, ¬IN, or NIN, and the column is alphanumeric, you must enclose each value in quotation marks.

If the data type of the column is alphanumeric, the value can be:
  • A character string not starting or ending with a single quotation mark. and not containing any embedded quotation marks or commas. The case of the string is ignored.
  • A character string enclosed in single quotation marks. The string can contain blanks and commas, but not any embedded quotation marks. The case of the string is ignored.

If the data type of the column is numeric, the value must be numeric.

For DATE, TIME, and TIMESTAMP columns, if you specify a = in the Value field, FM/Db2 displays the current date, time, or timestamp values respectively in the required format.

)
Right parenthesis column.

If you need to define the sequence of evaluation for the resultant WHERE clause by enclosing part of the clause in parentheses, use this column to type a right parenthesis (")") at the appropriate point.

You can only use parentheses on lines containing expressions (that is, where you have specified an operator in the Op column). The number of left parentheses must match the number of right parentheses.

Parent panels

Child panels

None.

Related tasks