Keywords › Keyword Descriptions › EDIT › Parameters

Parameters

EDIT supports the following parameters:

field-name

Use field-name when referencing a data field that is defined in the record's layout. The use of field-name requires that the record's layout be available to the CA File Master Plus job step. For more information on how to make the record's layout available, see the keyword LAYOUTFILE.

Note: When this parameter is supplied, the keyword's position, length, decimal-positions, and data type are all retrieved from the field-name definition, and are used to validate the from-data and to-data's formats.

position

The position in a record. Valid choices are the following:

1–32760

The actual position number.

+nnn or –nnn

The relative position to the record's current location

scan-length

Amount of data to scan. A scan-length of zero means to scan the entire record starting at the position parameter's value. Valid values are 0 – 32760. If the scan-length is omitted, no scanning is done.

operator

Valid choices include the following:

CO

Contains - If a field-name is supplied, the position and scan-length values are retrieved from the field-name's defined starting position and physical length. If position and scan-length are supplied, the record is scanned for the data beginning at position for a length of scan-length.

EQ

Equal

NE

Not equal

GT

Greater than

GE

Greater than or equal to

LE

Less than or equal to

LT

Less than

from‑data

Valid choices include the following:

C'c…'

Character—matches specified case

N'n…'

Numeric—processes the literal as defined by the field-name parameter. The field-name parameter must be defined as a numeric field, and it is only valid when a field-name parameter is supplied.

P'n…'

Packed

T'c…'

Text—matches both lower and uppercase alphabetic characters. Alphanumeric characters are permitted.

X'hh…'

Hexadecimal

to‑data

Valid choices include the following:

C'c…'

Character—matches specified case

N'n…'

Numeric—processes the literal as defined by the field-name parameter. The field-name parameter must be defined as a numeric field, and it is only valid when a field-name parameter is supplied.

P'n…'

Packed

T'c…'

Text—upper case letters are substituted for their lower case counterparts. Alphanumeric data is permitted.

X'hh…'

Hexadecimal

ALL

Changes every occurrence in the record within the scan-length. Otherwise only the first occurrence of the from-data is edited. The scan-length parameter must be present if this parameter is specified.

Example

Replaces all occurrences of the value 'DSNAME=' with the value 'DSN=.' Because EDIT is used to change text type data, data is shifted to the left until a double space is found and padded with the PADCHAR value, spaces.

UPDATE,
  EDIT(1,0,C'DSNAME=',C'DSN=',ALL),PADCHAR(C' ')