Selection Criteria Menu panel
The Selection Criteria Menu, shown in the following figure provides access to the selection criteria options and formatted selection criteria specification.
Selection Criteria Menu
Option ===>
- Status -
1 OPTIONS - Enter selection criteria options default
2 FORMATTED - Edit formatted selection criteria 0 sets
Use VIEW to display selection criteria summary
Use END to save selection criteria & return to Object Selection Criteria
Use CANCEL to cancel changes & return to Object Selection Criteria
The Selection Criteria screen contains the following fields:
Option
Enter one of the following valid options:
1
Selection criteria options allow you to specify a particular starting point in the file and set limits on the number of records processed. See Selection Criteria Options.
2
Create and edit formatted selection criteria, which allows you to select records based on data within a field specified by a record layout. See Formatted Selection Criteria Screen.
Status
Specifies the status of the temporary selection criteria:
OPTIONS
Reports whether the default options have been modified. Valid values are DEFAULT or NOT DEFAULT.
FORMATTED
Specifies the number of sets of criteria that are specified. A set of selection criteria is defined as a single expression that can lead to the selection of a record. A set may test for one condition or several conditions. The conditions can be ANDed together and several conditions separated by commas create nested OR conditions within a set.
Primary Commands
The following primary commands are valid on the Selection Criteria Menu:
CANCEL
Returns to the Object Selection Criteria and clears all selection fields.
END
Saves the current selection criteria display and exits the Selection Criteria Menu without clearing the selection fields.
VIEW
Displays the View Criteria screen, which summarizes the options and formatted selection criteria sets into a scrollable display. See View Criteria.
View Criteria
The View Criteria screen, shown in the following figure, summarizes the current selection criteria. It displays selection criteria option settings and formatted selection criteria sets on a scrollable display. Use the VIEW primary command on any selection criteria screen to display this screen. Use the END command (PF3) to return to the previous screen.
View Criteria Screen
Command ===> SCROLL ===> CSR
Use END to exit View Display
******************************* TOP OF CRITERIA *****************************
DEFINE BLOCKS=SELECTION,
DESCRIPTION1="Selection Criteria for Data Driven AR",
LAYOUT_DSNAME=,
LAYOUT_MBRNAME=,
INITIAL_SKIP=0,
THEN_SELECT=1,
THEN_SKIP=0,
MAXIMUM_TO_SEARCH=ALL,
MAXIMUM_TO_SELECT=ALL
SELECT SET=1,LAYOUT=CUSTOMER_TABLE-TBL
IF
FIELD_NAME=CUSTOMER_NUMBER,
POSITION=17,LENGTH=6,OPERATOR=LT,
TYPE=T,VALUE=777777
Selection Criteria Options
The Selection Criteria Options screen, shown in the following figure, enables you to control record selection based on starting record key, RBA, or RRN or record counts which determine how selection processing is executed and when it stops. File-AID/RDX determines whether an individual parameter is valid based on the access method of the processed file. For instance, File-AID/RDX allows you to specify the processing direction when selecting records from a sequential or VSAM file.
Enter option 1 on the Selection Criteria Menu to display the Selection Criteria Options screen. Selection criteria options can be combined with formatted selection criteria. If any formatted selection criteria exist, they are applied after a record passes the selection criteria options selection process.
Selection Criteria Options
Command ===>
Specify Selection Criteria Options:
Start at the following record key
(both blank for start of dataset)
Starting record key ===>
- OR - OR at the following RBA or RRN
Starting RBA or RRN ===>
Initial records to skip ===> 0 then skip this many
Subsequent Selection Interval: then repeat the following
Records to select ===> 1 - select this many records
Records to skip ===> 0 - then skip this many records
until
Number of records to search ===> ALL you have read this many records
SEQ/VSAM processing direction ===> F (F = Forward; B = Backward)
Use ENTER to return to selection criteria menu
Specify Selection Criteria Options:
The Starting record key field and Starting RBA or RNN field are exclusive of each other.
Starting record key
Specify a generic or specific record key in a character or hexadecimal data format. This field allows you to specify a random starting point for record selection in a VSAM KSDS file. Records before the starting record key are not selected, regardless of matching formatted selection criteria.
To specify a hexadecimal record key, enter the value enclosed in single quotation marks ( ’ ) and precede the quoted value with the letter X. For example, X’03E2’.
Starting RBA or RRN
Specify a generic or specific relative byte address (RBA) or relative record number (RRN).
This field allows you to specify a random starting point for record selection in a VSAM or BDAM file. Records before the specified starting RBA or RRN are not selected, regardless of matching formatted selection criteria.
For VSAM KSDS and VSAM ESDS files, enter a specific relative byte address. RBAs must be on a record boundary. To specify a hexadecimal RBA, enter the value enclosed in single quotation marks (’) and precede the quoted value with the letter X.
For VSAM RRDS or BDAM files, a relative record number (RRN) can be specified.
Initial records to skip
Specify a number of records for File-AID/RDX to skip before processing the file. Possible values are any number from 0 (zero) through 999999. Use the 0 (zero) value to process all records.
Subsequent Selection Interval:
The values in the Records to select and Records to skip fields determine the record selection pattern that File-AID/RDX uses to select records from a file until the value in the Number of records to search or the Number of records to select field is reached.
Records to select
Specify the number of records for File-AID/RDX to retrieve from the file at a time. Possible values are any number from 1 (one) through 999999. Selection criteria is applied after the record has been retrieved. The default is 1 (one).
Records to skip
Specify the number of records for File-AID/RDX to skip after fulfilling the Records to select parameter when processing the file. Possible values are any number from 0 (zero) through 999999. Use the 0 (zero) value for File-AID/RDX to process all remaining records. All skipped records are not selected, regardless of the selection criteria specified.
Number of records to search
Specify a limit for the number of records File-AID/RDX reads and checks for matches to selection criteria. The default for this parameter is ALL. Possible values are any number from 0 (zero) through 999999. Use the 0 (zero) or ALL value to search the entire file.
This parameter can prevent excessive I/O processing when searching large files. If the file is processed randomly (a KEY or RBA have been entered), this count begins with the first record retrieved randomly.
SEQ/VSAM processing direction
Specify a processing direction for File-AID/RDX to read Sequential or VSAM files. Possible values are F (forward) and B (backward). The default is F (forward).
This field specifies whether File-AID/RDX starts reading a Sequential or VSAM file at the beginning or the end. File-AID/RDX ignores the B value in this field when used with files of other access methods.
The following figure shows an example of the effect of selection criteria options.
Selection Criteria Options Example
Subsequent Selection Interval: then repeat the following
Records to select ===> 2 - select this many records
Records to skip ===> 3 - then skip this many records
until
Number of records to search ===> 10 you have read this many records
NS Record 1
NS 2
NS 3
NS 4
S Select 2 5 <=== Starting Record Number
S 6
NS Skip 3 7
NS 8
NS 9
S Select 2 10
S 11
NS Skip 3 12
NS 13
NS 14
S Select 2 15
S 16
NS Skip 3 17
NS 18
NS 19
S Select 2 20
S 21
NS Skip 3 22
NS 23
NS 24
S Select 2 25
S 26 <=== 10th Record Searched
NS 27
NS 28
NS 29
NS Not Searched 30
NS Because Limit 31
NS Has Been Reached 32
NS 33
NS 34
NS 35
When the values shown in the following figure are entered in the selection criteria options fields, all records in the file pass this portion of the selection process and are processed by any specified formatted selection criteria.
Selection Criteria Options Example. Default - Examines All Records
Subsequent Selection Interval then repeat the following
Records to select ===> 1 - select this many records
Records to skip ===> 0 - then skip this many records
until
Number of records to search ===> ALL you have read this many records
Related topics