Need to stop sorting after 570 records

khkalyan · New User Joined: 14 May 2007 Posts: 5 Location: India

I have a file of 1000 records . I need to stop sorting after 570 records .
can any one of you resolve it.

Raphael Bacay · Posted: Thu May 17, 2007 1:58 pm

There could be problems with your requirement. The problem is that for example, the lowest element is in the 1000th position. If you want to sort the first 570 records only, you will miss out the first element of the 1000 element file because you will never get to the first record with the 570 limit. You might want to just sort everything up, all 1000, and then extract the first 570 so you get the 570 records in sorted order. You can use IDCAMS-REPRO with COUNT for this or make a COBOL program to extract the first 570 elements.

If you insist that you only need the first 570 elements then you can just extract the first 570 records using IDCAMS-REPRO with COUNT or COBOL. Then you can use COBOL or JCL to sort the 570 element file into sorted order.

If you are going to try the IDCAMS option for extract you might want to use the REPRO parameter with syntax:

REPRO -
INFILE(VSAM) -
OUTFILE(SEQ) -
COUNT(N)

You can then use SYNCSORT or COBOL for the sorting.

skkp2006 · Posted: Thu May 17, 2007 2:15 pm

STOPAFT Parameter (Optional) (SyncSort OS/DOS compatible)

STOPAFT=n instructs SyncSort CMS to sort or copy only a decimal number (n) of records. These will be the first 'n' records after E15, INCLUDE/OMIT and SKIPREC processing.

The STOPAFT parameter may be specified on the OPTION control statement, but should not be specified on both the SORT statement and the OPTION statement for the same application.

STOPAFT may also be specified as an option on the SSORT command line. If it is, it overrides any STOPAFT parameters on the SyncSort CMS control statements.

priyamnavada · New User Joined: 24 Dec 2005 Posts: 52 Location: hyderabad

Use STOPAFT=570

khkalyan · New User Joined: 14 May 2007 Posts: 5 Location: India

Sorry there is a confusion in my question.I want to write first 570 records of 1000 records in to separate output file.The processiong has to stop after wrirting 570 records.

SHAILESH OZA · New User Joined: 10 Jun 2005 Posts: 21 Location: Mumbai

Hi Chankravarti,

you can follow the below steps

1) First read the 570 records from the input file File1 and write these records into the output file2.

2) Then Sort the file2.

3) Then simply read the input file1 upto the record 570(you can use perform 570 times).

4) After that open the file2 in extend mode and append the records into it
after making sure that your pointer in the input file is at the record 571.

This is the logic only . Bytherway i will try to implement it and let you know

Anuj Dhawan · Posted: Thu May 17, 2007 3:24 pm

Hi khkalyan,

Used below JCL to check STOPAFT. It's working fair enough for your requirement.

khkalyan · New User Joined: 14 May 2007 Posts: 5 Location: India

Hi this is ok.But I need to do with JCL.

khkalyan · New User Joined: 14 May 2007 Posts: 5 Location: India

HI PRIYA THANKS A LOT

I GOT THE OUT FILE

Anuj Dhawan · Posted: Thu May 17, 2007 3:36 pm

Hi,

Just wanted to add the following in above,
I/P file contains 10 records & I want to stop sort after 5 records OR in other words, I want to sort first 5 records only.

for your situation:
I/P file contains 1000 records & you want to stop sort after 570 records OR in other words, want to sort first 570 records only.

Hope you got the solution.

khkalyan · New User Joined: 14 May 2007 Posts: 5 Location: India

HI ANJU I HAVE DONE LIKE THAT ONLY BUT I HAVE GIVEN LIKE THIS

//SYSIN DD *
OPTION COPY,
STOPAFT=5
/*

Anuj Dhawan · Posted: Thu May 17, 2007 3:46 pm

oopss..!..
my answer came bit late.!

Anuj Dhawan · Posted: Thu May 17, 2007 3:52 pm

aha..!!
You got the solution..good..!
By the way my name is Anuj & not Anju

ramfrom84 · New User Joined: 23 Aug 2006 Posts: 93 Location: chennai

HI ,

U can use STOPAFT in SORT similar in the IDCAMS we have one more Option

REPRO INFILE(INDD) OUTFILE(OUTDD0) SKIP(No of records) COUNT(mno of records)

Anuj Dhawan · Posted: Thu May 17, 2007 9:01 pm

ramfrom84 · New User Joined: 23 Aug 2006 Posts: 93 Location: chennai

Soory guys,, U can use IDCAMS, for Normal REPRO here.., It ll work... forgot about CONDCODE....