On Wed, 16 Sep 2020 20:17:10 +0000, Farley, Peter x23353 wrote:
>Thanks Sri, I am aware of the STOPAFT parameter, but it uses a hard-coded
>count. When the goal is to find ALL records with the selected values and one
>does not know in advance how many there are, it is not as helpful as it could
>be.
>
>I was thinking of a command similar to OMIT / INCLUDE, something like:
>
>STOPWHEN COND=(key value greater than this stop reading)
>
>E.G., STOPWHEN(1,3,'AC ')
>
I'm imagining something like:
...STOPAFT=1
...COND=(1,3,CH,GT,C'ABC')
Certainly stops at (almost) the right place. but Kolusu indicates, there's
no way to select COND=(1,3,CH,EQ,C'ABC') for output.
>-----Original Message-----
>From: Sri h Kolusu
>Sent: Wednesday, September 16, 2020 3:54 PM
>
>>>> When using SORT (either DFSORT or SYNCSORT) to select a relatively
>> small sample of records by (a) particular key value(s) from a *very
>> large* sequential file,
>
>You can use STOPAFT parm to stop reading the input once you get to a threshold
>value. For example if you have file with 300 million records and if you are
>only interested in only 100 records for the key 'ABC', then you can use the
>following
>
>//SYSIN DD *
> OPTION COPY,STOPAFT=100
> INCLUDE COND=(1,3,CH,EQ,C'ABC')
>/*
-- gil
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
