MVSFORUMS.com

Prayank · Posted: Mon Oct 13, 2003 4:33 am Post subject: Syncsort Include condition

Lets say I have following sort include condition:

SORT FIELDS=COPY
INCLUDE COND=(9,5,CH,EQ,C'12345')

I want that the execution of this step terminates the moment one record satisfying this condition is found (There will be only one record satisfying this condition in the input dataset. My input dataset is a VSAM KSDS). Is it possible to acheive this ?

kolusu · Posted: Mon Oct 13, 2003 4:41 am Post subject:

Prayank,

No. But if you know the record-no then you can use STOPAFT parameter.

kolusu

coolman · Posted: Mon Oct 13, 2003 8:02 am Post subject:

Prayank,
As Kolusu had stated it is possible with SORT but not very straightforward. However if you fileaid you can use this :

Frank Yaeger · Posted: Mon Oct 13, 2003 9:56 am Post subject:

Kolosu,

Unless STOPAFT works differently for Syncsort than for DFSORT (which I doubt), your response is incorrect (perhaps you were thinking of ENDREC rather than STOPAFT?). STOPAFT=1 will do what Prayank asked for. STOPAFT=n says to stop after n records have been accepted for sorting or copying.

Here's a DFSORT job that will do what Prayank wants:

kolusu · Posted: Mon Oct 13, 2003 10:20 am Post subject:

Frank,

I am mistaken Sad

You are absolutely correct. Thanks for correcting me.May be it is too early in the morning(5:41 am) that my brain cells are still sleeping while I am answering the questions.

Kolusu

coolman · Posted: Mon Oct 13, 2003 11:32 pm Post subject:

Frank,

Got confused between STOPAFT and ENDREC. Yep, SORT is really "straightforward". I agree with you. Mr. Green

Coolman.
________
weed vaporizers

Prayank · Posted: Wed Oct 15, 2003 5:24 am Post subject:

Thanks everyone for your replies. It helped me a lot.

I have another query which is an extension to the previous one.

Can I code this as
SORT FIELDS=COPY,STOPAFT=(9,5,CH,GT,C'12345')
INCLUDE COND=(9,5,CH,EQ,C'12345')

OR Is there any other method to stop once a condition is satisfied ?

PRAYank

kolusu · Posted: Wed Oct 15, 2003 6:59 am Post subject:

Pryank,

The only parameter that STOPAFT accepts is 'N' i.e STOPAFT=N

'N' should be an absolute number. STOPAFT=N causes sort to stop after 'n' records in the input file have been sorted or copied.

You can change the value of 'n' to the no: of records you want to copy

coolman · Posted: Wed Oct 15, 2003 7:19 am Post subject:

Prayank,
Whatever you have coded is not correct. STOPAFT tells you how many records have to be accepted for SORTING/MERGING.

STOPAFT=N, where N is an integer

Hope this helps...

Cheers,
Coolman.
________
Subaru Forester specifications