Specifying the selection criteria data sets


You must specify a partitioned selection data set to save your criteria members when using this function. The attributes of the data set are:

DSORG=PO,RECFM=VB,LRECL=300,BLKSIZE=x (x = 304 or more)

A sample Selection data set (FASAMP.SELCRIT) is created for you with your other training files.

Create a new member "GBLSTATE" to select employee file records that have a middle initial of "C" while the Global field & SAVESTATE equals “CA”. Use record layouts to define your selection using formatted field selection criteria.

When you define or maintain formatted field selection criteria members, you must specify a single record layout or an XREF member.

Selection Criteria - Dataset Specification screen

image2021-6-18_16-40-15.png

Steps:

  1. Type FASAMP.SELCRIT in the selection Dataset name field.
  2. Type GBLSTATE in the selection Member name field.

    If this member exists, you see the member and are able to specify and save changes. If this is a new member, you define and save a new criteria member. If you leave this field blank or use a mask (for example, MEM*), a member list is displayed from which you can select a member for criteria display and modification.

  3. Type S in the Record layout usage field.
  4. Type FASAMP.LAYOUTS in the Record layout dataset name field.
  5. Type EMPLOYEE in the layout Member name field.
  6. Press Enter. File-AID displays the Selection Criteria Menu screen as illustrated in Selection Criteria Menu Screen.

 

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