Selective SORT using SYNCSORT

Pritam Dass · New User Joined: 30 Jan 2008 Posts: 6 Location: Noida

HI,

I have a file in which first 5 records are header records ( Not the data only headings). From 6th record I have data which needs to be sorted.
My output file should contain first five records as it is copied from input and rest of the records should be sorted in a given order.

superk · Posted: Fri Feb 08, 2008 10:00 pm

You need to provide the details such as the RECFM and LRECL of the file, and in your case, what fields you want to sort on and their location and format in the file.

Pritam Dass · New User Joined: 30 Jan 2008 Posts: 6 Location: Noida

Thanks Kevin,

I am using SYNCSORT. RECFM=FB, LRECL=133.

SORT fields are (1,5,CH,A,30,14,CH,A,65,8,CH,A).

First Five records should not be considered for this SORT, and just copied in the output file. SORT should start from rec number #6 to EOF.

Currently I am doing it in following steps:

1. copy first 5 recs in temp file...F1.
2. SORT the input to output temp file (skiprec=5)...F2
3. Merge the files F1 and F2 using IEBGENER.

I want to do it in a single step if possible.

Aaru · Posted: Tue Feb 12, 2008 2:55 am

Pritamm,

Is there any way to differentiate the header records from the data records? If yes, give us the details.

Pritam Dass · New User Joined: 30 Jan 2008 Posts: 6 Location: Noida

Yes, All data records have date like 20080212 at location 45. Header records do not have date field at location 45.

Alissa Margulies · Posted: Thu Feb 14, 2008 1:18 am

Alissa Margulies · Posted: Thu Feb 14, 2008 1:35 am

Alissa Margulies · Posted: Thu Feb 14, 2008 1:39 am

Depending on what your header records have in the sort control fields, they may get re-ordered in my previous job. If this is the case, let me know and I'll modify the job for you.

Amit Banerjee · New User Joined: 12 Jan 2008 Posts: 14 Location: india

Hi.I think you can use this if u're sure that the first five records are headers
sort card -
SORT FIELDS=(1,5,CH,A,30,14,CH,A,65,8,CH,A)
STARTREC=6

krisprems · Posted: Thu Feb 14, 2008 4:07 pm

Try this untested SORT JCL,

Pritam Dass · New User Joined: 30 Jan 2008 Posts: 6 Location: Noida

Thanks for your response. I used the soultion mentioned by krisprems and it worked

.