Previous Topic: SyntaxNext Topic: EMPTYRC


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 layout must be available to the application's job step. For more information on how to make the record's layout available, see the keyword LAYOUTFILE.

Note: When this parameter is specified, the keyword's position, length, decimal-positions, and data type are 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

Specifies the actual position number.

+nnn or -nnn

Specifies the relative position to the record's current location

scan-length

Specifies the amount of data to scan. When scan-length is set to 0 means, the entire record starting at the position parameter's value is scanned. Valid values are 0 - 32760. If the scan-length is omitted, no scanning is done.

operator

Specify one of the following values:

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

Specify one of the following values:

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

Specify one of the following values:

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 the ALL 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' ')