Skip to Content
Information
Space announcement: BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.

Defining a compound AND condition

When you specify test conditions for more than one field in a criteria set, File-AID links the tests together (the tests are ANDed) and requires that all the conditions be true before it selects a record. You can use the REPEAT or INSERT command to add a new selection criteria set. Sets are ORed.

Formatted Selection Criteria - Compound AND Condition

image2021-6-15_10-26-11.png

Steps:

  1. Type LE in the RO column next to the field name EMP-LOCAL-TAX-WITHOLD-PCT.

  2. Type a 7 in data area to define the test.

    You have now created a compound criteria set matching records with MARITAL-STATUS EQUAL TO S and EMP-LOCAL-TAX-WITHOLD-PCT LESS THAN OR EQUAL TO 7.

  3. Notice the column offset (189) of the EMP-CON-HOME-PHONE field. In Unformatted Selection Criteria Screen. Testing for a List of Values you define a test to select records based on the value of the area code (first three characters of the PHONE field) using unformatted selection criteria.

  4. Type UNFMT in the COMMAND field.

    Instead of entering the UNFMT command, you could enter the END primary command to return to the Selection Criteria Menu and then select option 3 (Unformatted). Or, you could have entered the 3 command. 3 is an alias for UNFMT.

  5. Press Enter to display the Unformatted Selection Criteria screen.

Related topic

Defining-unformatted-field-selection-criteria

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Compuware File-AID/MVS 21.01