Selection Criteria Options panel

The following figure is displayed when you use Search/Update option U with non-PDS data set(s). It is not displayed for a PDS, Panvalet or Librarian data set. This screen enables you to specify a particular starting point in the data set or processing direction. It also set limits on the number of records to be processed.

Important

When executing the update, File-AID replaces the record select values of this Selection Criteria Options Screen with the values of the Maximum changes field specified in the Search/Update Utility Screen (without preview) or Search/Update Confirm Update Screen while honoring the other selection criteria options.

Selection Criteria Options screen

File-AID -------------- 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 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
   Number of records to select ===> 250    or selected this many records

SEQ/VSAM processing direction ===> F      (F = Forward; B = Backward)

   Use END key to continue to unformatted selection criteria

Important

When processing multiple data sets, SEQ/VSAM processing direction must be set to F (Forward); B (Backward) is not valid.

See Selection Criteria Options for Selection Criteria Options screen field descriptions.

Search/Update Change Criteria Screen

The following figure allows you to specify the data to search for and display or change when processing an update.

Column headings identify the selection criteria parameters. Each line of blank fields allows you to enter a set of selection criteria. The selection criteria sets are connected by AND/OR elements.

You can scroll the Search/Update Change Criteria screen down to enter additional criteria. Scrolling up displays previously entered criteria.

Search/Update Change Criteria screen

File-AID ------------- Search/Update Change Criteria ---- ROW 1 TO 12 OF 25
COMMAND ===>                                                  SCROLL ===> CSR

Use END command to continue, use CANCEL command to return to main screen.

Relational Operator R (Replace) overlays existing data. E (Edit) shifts
existing data. When preceded by CO (Contains), R or E changes first occurrence
of search value in each record, RA or EA changes all occurrences.

     AND
Cmd /OR Position Length RO             Search Value / Update Value
--- --- -------- ------ -- ----------------------------------------------------
___      _____   _____ CO ____________________________________________________
___      _____   _____ EA ____________________________________________________
___ AND _____   _____ __ ____________________________________________________
___ AND _____   _____ __ ____________________________________________________
___ AND _____   _____ __ ____________________________________________________
___ AND _____   _____ __ ____________________________________________________
___ AND _____   _____ __ ____________________________________________________
___ AND _____   _____ __ ____________________________________________________
___ AND _____   _____ __ ____________________________________________________
___ AND _____   _____ __ ____________________________________________________
___ AND _____   _____ __ ____________________________________________________
___ AND _____   _____ __ ____________________________________________________

Field descriptions

Field

Description

Cmd

Specify one of the following valid line commands to edit your selections:

A—Marks the destination after which a line is placed.
B —Marks the destination before which a line is placed.
C—Copy the line to a marked destination.
D—Delete the line. Dnn deletes the specified number of lines.
I—Insert a line. Inn inserts the specified number of lines.
M—Move the line to a marked destination.
R—Repeat the line. Rnn repeats the line the specified number of times.

AND/OR

Specify the AND/OR parameter to define multiple condition testing. It defines the logic to use to connect multiple conditions.

File-AID considers the OR connector the beginning of a new logical set of change specifications. AND continues a logical set of change criteria.

When evaluating ANDed conditions, all the conditions must be true. When evaluating ORed conditions, only one of the conditions must be true.

For example, if you specify: Selection 1 AND Selection 2 OR Selection 3, File-AID evaluates it as: (Selection 1 AND Selection 2) OR Selection 3.

Use File-AID option 0.2 System Parameters to set the default for the AND/OR field. Each selection can have multiple OR conditions as described in Multiple Data Entries.

Position

Specify the location within a record where File-AID is to begin the data comparison. The position value can be either actual or relative. An actual position is indicated by an unsigned number. A signed number (+ or -) indicates a relative position.

An actual position can be any number from 1 (one) to the maximum record length of the input file.

A relative position can be specified when scanning a record with the CO (contains) relational operator. It is a signed (+ or -) number that indicates an offset from the beginning of the matched data. Relative position (+0) points to the first byte of data of the matched scan. If no scan is defined, relative position (+0) points to the first byte of data in the record. A relative location cannot point to a position outside the record.

Variable-length records begin with a four-byte Record Descriptor Word (RDW). Position one points to the first byte of the data portion of the record. If you want to reference the RDW, use a relative position of -4.

Length

Specify the field length. Length is an optional field for most relational operators. VA, NV, VU, and NU relational operators are the exception and this field is required unless you specify packed data.

The length value plus the position value cannot exceed the record length. The value you specify in the Length field must be equal or greater than the length of the data value in bytes.

For the CO (contains) and NC (not contains) relational operators, the Length field specifies the number of positions in the record that File-AID scans for the specified data value. The length value can be from 1 to the maximum record length. If the Length field is left blank, each record is searched from the location specified in the Position field to the end of the record.

For the remainder of the relational operators, length defines the number of positions in the record that File-AID compares. The length value can be from 1 to 256.

If the Length field value exceeds the actual length of the data specified in the data value field, File-AID pads the data value with blanks to the right. When the Length field is left blank, File-AID determines the length of the field based on the actual data value length.

Specify a relational operator. File-AID is distributed with a default value of EQ (equal) for relational operator. Valid values are:

Conditional operators:
EQ, =	Equal to
NE, ¬=, !=	Not equal to
GT, >	Greater than
GE, >=	Greater than or equal to
LT, <	Less than
LE, <=	Less than or equal to
CO	Contains; scans a range of record positions for the presence of the data value. CO works on an equal condition. It reads from the Position value until the data string is matched, the Length value is exceeded, or the end of the record is reached.
NC	Not contains; scans a range of record positions for the absence of the data value. NC works on a not equal condition. It reads from the Position value until the Length value is exceeded or the end of the record is reached.
BT	Between; the value is greater than or equal to the first endpoint and less than or equal to the last endpoint.
NB	Not between; the value is less than the first endpoint or greater than the last endpoint.
VA	Valid character, text, numeric, or packed data based on the specified data type. VA operator will treat character and text as numeric. For a numeric data type, you must specify a length.
NV	Not valid numeric or packed data based on the specified data type. NV operator will treat character and text as numeric. For a numeric data type, you must specify a length.
VU	Valid unsigned display numeric data based on the specified data type where the last digit must not contain a sign. VU operator will treat character and text as numeric. For a numeric data type, you must specify a length. VU cannot be used on packed data.
NU	Not valid unsigned display numeric data based on the specified data type where the last digit must not contain a sign. NU operator will treat character and text as numeric. For a numeric data type, you must specify a length. NU cannot be used on packed data.

Bit relational operators used with the M (mask) data type:
EQ	Bits are all ones
MX	Bits are mixed, ones and zeros
NE	Bits are all zeros
NO	Bits are not all ones.

Replacement operators
E	Edit. Replaces data in the record with data of a different length. Data is shifted to adjust for the change. The edit operator changes only the first occurrence of matched compare data in the record.
EA	Edit all. Replaces data in the record with data of a different length. Data is shifted to adjust for the change. The edit all operator changes all occurrences of matched compare data in the record. Note: The EDIT ALL functionality will not expand variable length records.
R	Replace. Replaces data in the record at the specified location with new data. Existing data at the replace location is overlaid with the full length of the new data. The replace operator replaces only the first occurrence of matched compare data in the record.
RA	Replace all. Replaces data in the record at the specified location with new data. Existing data at the replace location is overlaid with the full length of the new data. The replace all operator replaces all occurrences of matched compare data in the record.

Bit replacement operators to use with the M (mask) data type code
XI	Exclusive OR means flip bit.
OI	Turn bit on.
NI	Turn bit off.

Search value / Update value

Specify the data string for which File-AID is to search and the required update value to use in modifications. All data types are supported.
If a data type code is specified, the data string must be enclosed in single (' ') or double (" ") quotes. When a data-type code is not specified, alphanumeric text is assumed.

The update value can have the same or a different length or data-type code as the search value. The update value is changed to uppercase unless it is specified as "C" character data which is case-sensitive.

Japanese Data:

DBCS and single byte Katakana data is accepted as data values for C (Character) and T (Text) data types. File-AID removes any leading or trailing shift characters from DBCS data unless the value is enclosed in double quotes.

When KANA is specified for the Character Set option on the System Parameters screen (option 0.1), C (Character) and T (Text) identifiers are both treated as case-sensitive C (Character) data.

The following table describes valid data-types codes for this field:

Data Type	Type Description	Example	Description of Data
B	Binary	B’+147,-25,+1117’	Binary equivalent of decimal number specified in quotes. In this example using the default of fullword, File-AID searches for 00000093, FFFFFFE7, or 0000045D. File-AID assumes the length of 4 or you can specify 1, 2, 4, or 8. Note: If the binary data in the record contains a sign, all data values must also contain a sign (+/-).
C	Character	C’Smith’	Case-sensitive character value of uppercase S and lowercase mith.
X	Hexadecimal	X’0001FF’	Hexadecimal value 0001FF.
M	Mask (Use with bit relational operators)	M’11000000’ or M’C0’	The mask can be specified in binary or hexadecimal to indicate which bits File-AID should examine. This example tests the first two bits of the specified byte.
N	Numeric	N’25’	Positive or unsigned numeric value +25 or 25.
P	Packed	P’12345’	Positive or unsigned packed value.
T	Text	T’smith’	Alphanumeric text, not case-sensitive. Value smith, SMITH, or any combination of upper and lowercase characters. T (text) is the default data type.

Guidelines

Use the T data-type code to have File-AID search for the string regardless of case (upper or lowercase). \
Use the C code to search for case-specific character data, that is, to search for both upper and lowercase data exactly as it is specified.
When specifying packed data, specify only significant digits. File-AID scans for the sign to determine the length of the packed field.
Hexadecimal data must be specified in multiples of two alphanumeric characters.
Use a mask data-type for testing individual bits in a single byte. Specify the mask data as either eight bits or two hexadecimal symbols with a bit relational operator. The bit replacement operators, XI, OI, and NI are used when changing individual bits in a single byte.

Multiple Data Entries

When you specify multiple data entries in one field, separate each entry with a comma. The comma is interpreted as OR. This gives File-AID the ability to search for multiple data values at a specified position. For example: smith,jones.

In this case, File-AID searches for the non-case-specific values of smith or jones at the specified location.

Important

Multiple data entries are not permitted with replacement operators E, EA, R, and RA.

Comma Character as Data

Since File-AID interprets a comma as OR, the syntax of the search data is important. To search for a comma as data, enclose the data in double quotes ( " " ). Using no quotes or single quotes around a comma causes it to be treated as OR. For example: ",DSN=". In this case, File-AID searches for a comma that is part of the ,DSN= data string.

Duplication Factor

File-AID allows you to specify a a duplication factor, which eliminates the need to code repetitive data. The duplication factor is a number from 1 through 255 that specifies the number of times that File-AID contiguously scans for the specified data value.

A duplication factor is not allowed with the NE (not equal), CO (contains), and NC (not contains) relational operators.

Invalid and Valid Data Checking

For the VA (Valid), NV (Not Valid), VU (Valid Unsigned), and NU (Not Valid Unsigned) relational operators, the Length field determines the portion of each record that is tested for validity.

For VA and NV, only data types C (Character), T (Text), P (Packed), and N (numeric) are valid and one must be specified as the only entry in the Data Value area. Character and Text are treated as Numeric.

For VU and NU, only data types C (Character), T (Text), and N (numeric) are valid and one must be specified as the only entry in the Data Value area. Character and Text are treated as Numeric.

For VA, numeric data is valid if all digits (0-9(x'F0-F9')); the low order digit may contain a C or D zone.

For VU, numeric data is valid if all digits (0-9(x'F0-F9')), including the low order digit. The low order digit must contain an F zone.

Duplication factors are permitted - Ex. VA 5P (five valid packed fields).

For P (Packed) testing, the Length may be left blank for VA, File-AID will automatically determine length.

Preview Changes With ISPF Browse

The following figure allows you to preview the changes you have requested with the Search/Update utility before the actual changes are made to your data set(s). The following figure shows an example with multiple data sets. The number of displayed changes is determined by the Maximum changes field on the Search/Update Utility screen.

Preview Changes with ISPF Browse Screen

BROWSE    USERID0.FILEAID.WF.D15056.T072247       Line 00000000 Col 001 080
Command ===> ____________________________________________ Scroll ===> CSR
********************************* Top of Data **********************************
==>USERID0.FASAMP.EMPLOYEE OPENED AS KSDS,LRECL=198,KEYLEN=5,VOL=PR0926
-------------------RECORD-1,RBA-0,LENGTH-198,KEY=00090-------------------
00090MARTIN        CHARLES   M AIRPLANE MANUFACTURER     427890125 1019549
-------------------RECORD-15,RBA=2840,LENGTH=198,KEY=39310--------------
39310BARNETT       CHARLES   E SALESMAN                  543789142 0809549

==>USERID0.FASAMP.EMPMAST OPENED AS PS,RECFM-FB,LRECL=198,BLKSIZE=1980,VOL=PRD92
-------------------RECORD-101-------------------------------------------
00090MARTIN        CHARLES   M AIRPLANE MANUFACTURER     427890125 1019549
-------------------RECORD-115-------------------------------------------
39310BARNETT       CHARLES   E SALESMAN                  543789142 0809549

******************************** Bottom of Data *******************************

XVJER881 ER881 - Input datasets = 2, Selected datasets =2 , Records read =
100, Listed =4 with changes

Search/Update Confirm Update

The following figure is displayed upon exit from the Preview Changes screen. It summarizes the changes that File-AID is about to make and gives you the option to overtype the displayed default values. Press Enter to proceed with the changes. Use the END command (PF3) to quit the procedure and redisplay the initial Search/Update Utility screen.

Important

When you apply changes, all records are examined and the number of changes you specify here in the "Maximum changes" field are performed. The preview may only show you a limited number of changes (if you specified a numerical value in the "Maximum Changes" field on the Search/Update utility screen).

For non-PDS data sets, the update is performed according to the selections specified in the Selection Criteria Options Screen with the "Maximum changes" value replacing the “Number of records to select” from the Selection Criteria Options Screen.

Search/Update Confirm Update Screen

File-AID -------------------- Search/Update Confirm Update ------------------
COMMAND ===>
  XVJER881 ER881- Input datasets = 3, Selected datasets = 2, Records read =
  150, Listed = 4 with 4 changes

  Ready to perform update

  Perform update           ===> Y       (Y = Yes; N = No)
  Print previewed changes ===> N       (Y = Yes; N = No)
  Maximum changes          ===> ALL     (All or number of changes to perform)

  Instructions:

  Use ENTER to perform above actions and return to the initial screen
  Use END to exit without UPDATE or PRINT

Selection Criteria Options panel

Search/Update Change Criteria Screen

Field descriptions

Guidelines

Multiple Data Entries

Comma Character as Data

Duplication Factor

Invalid and Valid Data Checking

Preview Changes With ISPF Browse

Search/Update Confirm Update

BMC AMI DevX File-AID/MVS 23.01

On this page