Entering criteria by field

"Criteria by field" expressions can be entered on any of these panels:
  • Dynamic Template
  • Record Identification Criteria
  • Record Selection Criteria
  • Related ID expression panel

For the purpose of entering criteria "by field", these panels operate in an identical manner.

To enter a single criteria expression by field:

  1. Display the appropriate panel for your needs.
  2. Type an operator in the Op field and a value in the Value field.
  3. Press Enter.

    Z Data Tools evaluates the expression to see if it can be processed internally or needs to be passed to REXX. If REXX is required, the message “REXX required” is displayed in the upper right corner when you press Enter on the relevant panel. You can choose to either modify the expression so that REXX is not required, or use the expression with REXX processing instead of internal processing.

Note: When exiting from the Record Identification Criteria or Record Selection Criteria panels, your "by field" expression replaces any existing freeform expressions in the relevant field of the Field Selection/Edit panel.

To enter multiple criteria expressions by field:

  1. Display the appropriate panel for your needs.
  2. Type an operator and value for the each criteria in the appropriate fields.
  3. Where you want to use the same field for a number of different criteria, use the available prefix commands to copy and rearrange field definitions within the panel.
  4. Use the AND and OR connectors to join the various expressions.
  5. Use the ( and ) parenthesis fields to group your expressions.
  6. Press Enter.

    Z Data Tools evaluates the expression to see if it can be processed internally or needs to be passed to REXX.

For example, using the sample data, you may want to display all the Programmers or Developers in your list. To do this, you would need the Job Title field to appear twice in the panel, each with an operator and value, and you would use the OR connector to join them.

⋮
Cmd Con ( Field Name           Op  Value                                      )
*** ****  Top of data  ****
___ ___ _ REC-TYPE02           ___ __________________________________________ _
___ AND _ REC-TYPE             ___ __________________________________________ _
___ AND _ NAME                 ___ __________________________________________ _
___ AND _ JOB-TITLE            =__ Programmer________________________________ _
___ OR_ _ JOB-TITLE            =__ Developer_________________________________ _
___ AND _ ADDR1                ___ __________________________________________ _
⋮