Condition Specifications

The following table shows some sample condition specifications.

Condition Specification

Description

MEMBER

Specifies that subsequent selection condition apply to PDS member selection only. This parameter and subsequent selection criteria are ignored if specified for non-PDS data sets.

RECORD

Specifies that subsequent selection condition apply to record selection only.

101 = C'NY'

Position 101 for a length of 2 equals 'NY'

1(3) = C'001'

Position 1 for a length of 3 equals '001'

C'TEXAS'

Character string 'TEXAS' anywhere in the record

'TEXAS'

Character string 'TEXAS' anywhere in the record

1(3) = C'001' & 101 = C'NY'

Compound condition

10(4) EQP

Pos 10 for a length of 4 is a valid packed value

80 = C'NY' C'NJ' C'MA'

Position 80 equals one of the three values

80 = C'NY,NJ,MA'

Position 80 equals one of the same three values

100(2) = P'0,1,999'

Two-byte packed field equals one of three values

100 = C"100,00"

Position 100 for a length of 7 equals '100,000'
Note: Quotes are required when the search string contains a comma

82(2) > 84

Compare position 82 to position 84 for length of 2

101(20) CO C'NEW YORK'

Looks for the character string in columns 101-120

INLIM(5000)

Stop reading/selecting after reading 5000 records.

SELLIM(1000)

Only select 1000 records based on selection criteria

STARTKEY='56789'

Select keyed VSAM records starting with key '56789'

STARTREC=1001

Select records starting with record number 1001

STARTRBA=X'1FD8'

Select records starting with the record with RBA x'1FD8'

More information:

Filters

Create and Use Cataloged Filters

Create and Use Uncataloged Filters