Filters › Create and Use Cataloged Filters › Define Selection Conditions

Define Selection Conditions

Selection criteria contain selection conditions that identify specific records or members in a data set. Cataloged filters use selection criteria that are stored in a data set. Consider the selection criteria that currently exist and determine if any of them meet your needs entirely. If no existing selection criteria meets your needs, you can modify an existing selection criteria or create a new one. Changes to existing selection criteria are automatically saved.

Follow these steps:

1. Select FILTER from the Main Menu (option 5).

   The Define or Update a Selection Criteria screen opens.

2. Complete the following fields:

   DSN

   Identifies the data set name of the data set that contains the selection criteria that you want to modify. A wildcarded DSN retrieves a list of data sets from which you select the data set that you want.

   If you are creating a selection criteria, this field defines the selection criteria data set in which you want to store the new member.

   Member name

   Defines the member name of the filter you want to modify or create, if the selection criteria is a member in a PDS.

   Leave blank or type a wildcarded member name to display a directory of existing members from which you can select the member that you want to update.

3. Press Enter to validate the entries.

   The Update Selection Criteria screen opens. The Selection DSN and Selection Member fields display the information you entered in the previous step.

4. Complete the following fields:

   Description

   Describes the purpose of the selection criteria.

   Layout data set

   Defines the data set name that contains the record layout to use to build condition lines for the selection criteria.

   Layout member set

   Defines the member name of the record layout to use to build condition lines for the selection criteria.

5. Type LAYOUT at the command prompt.

   The Selection Criteria Condition screen opens.

6. Move your cursor to the line containing the selection criteria that you want to use.
7. Complete the following fields:

   OP

   Defines the condition for the selection condition.

   Valid values:

   = or EQ—Equal

   ^= or NE—Not equal

   > or GT—Greater than

   < or LT—Less than

   >= or GE—Greater than or equal

   <= or LE—Less than or equal

   CO—Contains

   Compare Value/Field Name

   Defines the literals to which the field is compared or the field name of another field to which the field is compared.

   Valid values:

   • Alphanumeric literals contain a value within quotes. Precede the first quote with one of the following letters:

     C—Compares the exact string within the quotes.

     T—Compares the string within quotes without regard to case.

     X—Compares the hexadecimal values.

   • Numeric literals are defined without quotes or within quotes preceded by a designation of the field format (such as P'0' or N'0').
   • Multiple literals evaluate a field against multiple values.

   For example, as an insurance claims analyst, you would create the following selection conditions to find all automobile claims in Boston since 2010:

   • Claim_year GT C’2010’
   • Claim_type EQ T’auto’
   • City EQ T'boston’
   • State EQ T'ma’
8. Type End.

   The Define or Update a Selection Criteria screen displays.

9. Type End.

   The main menu displays.