Sort Query to fetch particular records

SanaR · New User Joined: 04 Feb 2016 Posts: 15 Location: Lithuania

Hi All,

Is it possible to achieve the below:

Below is the sample input record and the output expected
Is this is possible using a sort jcl?
I just want the records at 1,5,10 etc. Since the file is in production I dont have access to view it directly.
INPUT: ABCXYZ.UTIL.TEST
AB
AB
DC
DC
DC
PQ
PQ
SR
RQ
CD
AB
CD
CD
AB

Output expected:

1 AB 4
5 DC 3
10 CD 3

Where 4, 3, 3 are the number of occurrences

enrico-sorichetti · Posted: Fri Mar 04, 2016 8:34 pm

is the 1,5,10 sequence fixed
and the counting until the end of file ?

SanaR · New User Joined: 04 Feb 2016 Posts: 15 Location: Lithuania

Yes the sequence number is fixed but it not multiple. For example it can also be 1,6,8,11 etc until end of file. I also want the last record of the file.

enrico-sorichetti · Posted: Fri Mar 04, 2016 8:50 pm

RahulG31 · Active User Joined: 20 Dec 2014 Posts: 446 Location: USA

Make use of SECTIONS and SEQNUM and filter whatever records you like.

Something on the lines of:

SanaR · New User Joined: 04 Feb 2016 Posts: 15 Location: Lithuania

Hi Erico,

the sequence is assumed say 1, 6 10 and last records. There is no particular format.

SanaR · New User Joined: 04 Feb 2016 Posts: 15 Location: Lithuania

Hi Rahul,

Thanks for your reply but this doesn't give me the record on 1,6,10th or the last positions.

Bill Woodger · Posted: Sun Mar 06, 2016 3:53 am

SanaR,

It should strike you, forcefully, that you know what you want, and no-one else does.

If you cannot describe exactly what it is is that you want, with sample input and expected output which matches your exact description, the topic will be locked, as it can go nowhere. It is up to you.

SanaR · New User Joined: 04 Feb 2016 Posts: 15 Location: Lithuania

Hi Bill,

I have clearly mentioned the sample and expected output. And I have also mentioned that the file is in prod so I cannot view it and the only thing that can be assumed is record at line number say 1,6,10 and last record

Nic Clouston · Posted: Sun Mar 06, 2016 5:01 pm

You will have to get a copy of the dataset (not 'file') cut and paste some of the data (after concealing sensitive data) and describe what you want more fully. You will need a copy anyway so that you can test the solution.

Do you want the 1st, 6th, 10th and last records no matter what their content? If not, what is the criteria? What are the dataset characteristics - RECFM and LRECL? What if there are 10 records? Do you want the 10th record twice? What if there are less than 10 records?

SanaR · New User Joined: 04 Feb 2016 Posts: 15 Location: Lithuania

Thanks Nic for your reply.

The situation is I will be unloading the data from image copy of a table which has nearly 30 million records. Data set in which I will be unloading will be PS, FB, 20 bytes(20 bytes can change) . Then I would like to fetch records at line 1, 15000000, 29923210 and last records. The only thing I will know is these line numbers and that the records are 30M. The records key is from 1-19. Please let me know if I am still unclear.
Sorry not able to paste the sample file image. so pasting this:

enrico-sorichetti · Posted: Sun Mar 06, 2016 9:37 pm

SanaR · New User Joined: 04 Feb 2016 Posts: 15 Location: Lithuania

Apologies as this my first query and I appreciate everyone's time.

Yes the record no. is fixed in value and number. In the above response I have provided the input file to the sort and the expected output should be something like below:

Bill Woodger · Posted: Mon Mar 07, 2016 12:42 am

It is difficult to tell (in your latest sample input you only show one key) but is your data in key sequence already? Your earlier example showed not.