Selection Criteria Options screen
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.
Selection Criteria Options screen
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
Field Descriptions
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.
RO
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 Types
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.
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
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.
Search/Update Confirm Update Screen
Related topics