Field Descriptions

Utility Functions › Update Utility › Update File/Members › Field Descriptions

Field Descriptions

Update Dataset

Dataset name

Type the DSN of the file to be updated. This file can be a sequential file, partitioned data set, or VSAM file.

Member name

When the input file is partitioned, you may leave the member name blank or type a wildcarded specification to get a list of all members that match the wildcard member name plus any additional MEMBER selection criteria that was specified. Once the member list is displayed, you can select one or more members for processing or specify additional MEMBER selection criteria.

If you specify an *, the member list does not display and all members in the data set or members that match any additional MEMBER selection criteria will be immediately searched or updated.

Volume serial

If the input data set to the updated is uncataloged, you must type the volume serial of the volume on which the data set resides.

Update / Preview Data Set

Data set name

The Update Preview data set name is optional and when specified is used as an output data set by the update function when Preview for Update is specified.

When you request an update function and the Preview for Update option is also specified, this data set will contain the updated records.

If you specify a DSN, it will be deleted and re-allocated with the appropriate characteristics required to hold the records from the Update data set. Upon completion of the function, a Browse screen displays showing the records that matched the search or update criteria.

If you do not specify a DSN, a temporary data set will be allocated.

Update Parameters

Preview Before Update

If you specify Preview Before Update, all updated records are written to the Update/Preview data set instead of the Update data set. No modifications are made to the Update data set. If Preview Before Update is performed for multiple members of a partitioned data set, the updated records will be preceded by a display of the member name. Preview Before Update can only be executed in online mode.

If Preview Before Update is not specified, updates are made directly to the Update data set.

Input Format JCL

This parameter is only valid for partitioned, fixed block, 80 byte records data sets. When you specify Y, the update function will maintain JCL formatting when making changes to a JCL record. JCL formatting is maintained by applying appropriate rules when updating from and to strings of unequal lengths so the updates do not cause JCL errors.

If the to character string is shorter than the from character string, data is shifted to the left until two consecutive spaces/blanks are found, then padded with spaces/blanks. If the to character string is longer than the from string and there are not enough consecutive blanks to accommodate the difference, a new (continued) JCL record will be inserted with one or more JCL parameters from updated JCL statement.

Execution Mode

The execution mode field is for the Update function and indicates whether to perform one of the following:

O—perform the update function online

S—create and submit JCL to perform the update function in batch

E—create and edit JCL to perform the update function in batch.

If you specify Preview before Update, execution mode must be O.

Record Layout

Layout data set

Type the DSN of the Record Description Copy Library member that describes the file to be searched. You can also type a wildcarded DSN to request a list of data sets from which you can select the desired data set. This field is required when using the LAYOUT primary command or when you want to use the Update by Field Name function.

Layout member

Type the Member Name of the Record Description Copy Member that describes the input file.

Leave this field blank to receive a directory of the members in the Layout data set. You can also type a wildcarded member name to receive a directory of members that match that wildcard.

You must complete this field to perform an Update by Field Name or to use the LAYOUT command.

Specify the LAYOUT command on this panel when you specify a layout data set and member and you also want to dynamically build the selection criteria by Field-Names defined in the record layout.

Selection Criteria

Selection criteria below or Selection criteria member

Specifies selection criteria if the records or members of the input file will be filtered according to selection criteria.

Use selection criteria to specify a filter based on the following types of parameters

Condition that evaluates data values in each record
Presence of a character string within a record or specified columns or field name from a record layout
Specification of the first record to be selected based on relative record number, VSAM key, or VSAM RBA
Limit to the number of records selected

Use a cataloged selection criteria parameter member that has been defined using CA File Master Plus Option 0.

Use the primary command LAYOUT.

For sample selection criteria specifications, see the following table. For a complete explanation of the syntaxes, request field-level help.

Selection Criteria	Description
101 = C'NY'	Position 101 for a length of 2 equals 'NY'
1(3) = C'001' & 101 = C'NY'	Compound condition
C'TEXAS'	Character string 'TEXAS' anywhere in the record
'TEXAS'	Text 'TEXAS' (any case) anywhere in the record. If the character string contains imbedded blanks or an imbedded operand, the character string must be within quotes.
10(4) EQP	Position 10 for a length of 4 is any valid packed value
80 = C'NY'C'NJ'C'MA'	Position 80 for a length of 2 equals 'NY' or 'NY' or 'MA' (case sensitive)
80 = C'NY,NJ,MA'	Position 80 for a length of 2 equals 'NY' or 'NY' or 'MA' (case sensitive)
100(2) = P'0,1,999'	Position 100 contains a two-byte packed value of 0 or 1 or 999
82(2) > 84	Position 82-83 is greater than positions 84-85
101(20) CO C'NEW YORK'	Positions 101-120 contain 'NEW YORK'. (case sensitive and can appear anywhere within positions 101-120)
STARTREC=1001	Select records beginning with record number 1001
STARTKEY='56789'	Select keyed VSAM records beginning with key 56789
STARTRBA=X'1FD8'	Select records starting with the record with RBA x'1FD8'
INLIM=5000	Stop reading/selecting after reading 5000 records.
SELLIM=1000	Only select 1000 records based on selection criteria
STATE-CODE NE 'NY'	Field STATE-CODE not equal 'NY' (requires LAYOUT information)
80 = C'NY' C'TX' AND 100 = C'000'	Position 80 for a length of 2 equals 'NY' or 'TX', AND position 100 for a length of 3 equals '000'
TRAN-DD GT '01' AND TRAN-DD LT '06'	Field TRAN-DD is '02' '03' '04', or '05'
MEMBER criteria	Specifies that 'criteria' (specified after the MEMBER command) applies to PDS member selection only. This parameter and subsequent selection criteria is ignored if specified for non-PDS data sets. Examples: MEMBER 'texas' MEMBER 101 EQ 'NY' MEMBER is the default for selection criteria specified for PDS or PDSE data sets when no member or a generic member name is specified.
RECORD criteria	Specifies that 'criteria' (specified after the RECORD command) applies to record selection only. When a data set or member(s) are selected for browse or edit, only selected records will be displayed. Examples: RECORD 'texas' RECORD 101 EQ 'NY' RECORD is the default for VSAM and sequential files or for fully qualified PDS-member names.