JCL - Pick up records with same values in a column

Prema Suresh · New User Joined: 12 Jun 2008 Posts: 6 Location: Bangalore

Hi all,

I have a requirement like this:
I have to sort a file based on update date field in descending order. I have to write into another file records with the latest datetime.

Eg:

asdfsfsf123423424sfffgdg200807210510
asdfsfsf123423424sfffgdg200807210510
asdfsfsf123423424sfffgdg200807210510
asdfsfsf123423424sfffgdg200807210520
asdfsfsf123423424sfffgdg200807200510

I want in the output first three records alone.In simple terms I have to stop after the sortkey changes its value from first value

Please help!

Frank Yaeger · Posted: Mon Jul 21, 2008 9:58 pm Post subject:

It's not clear what you want to do. You mention a sortkey, but it isn't clear what that sortkey is. It isn't clear if you want to keep records with the latest datetime of all of the records, or of each set of records with a particular key.

You need to do a better job of explaining what you want to do. Show a better example of the records in your input file with multiple sets of records to be kept if that's relevant, and your expected output. Explain the "rules" for getting from input to output. Give the RECFM and LRECL of the input file. Give the starting position, length and format of all relevant fields and keys.

Prema Suresh · New User Joined: 12 Jun 2008 Posts: 6 Location: Bangalore

I am sorry Frank. In an urgency I have posted with insufficient information.

I have a file whose last 8 characters form the update date information in the format yyyymmdd. Say a file of LRECL 80 with last 8 characters
forming the date field.
Input:

1234 asdf efgh ..........20080721
5678 asdf efgh ..........20080722
1111 asdf efgh ..........20080722
2222 asdf efgh ..........20080721
3333 asdf efgh ..........20080722

I wish to sort this file based on update date and then extract the records which were updated latest (the latest may/ may not be current date - Please give solution for both - 1. If i need to extract the file based on update date=current date - how to dynamically retrieve the system date and hence extract those records? 2. If i need to extract the records updated latest which is not equal to current date, then i should sort based on update date in descending order and then extract top few records till the update date doesn't change for the consecutive record from the previous one).

So required output:

5678 asdf efgh 20080722
1111 asdf efgh 20080722
3333 asdf efgh 20080722

Sort key is the last nine characters.

Please let me know in case you need further details

Frank Yaeger · Posted: Tue Jul 22, 2008 11:42 pm Post subject:

Prema Suresh · New User Joined: 12 Jun 2008 Posts: 6 Location: Bangalore

Thanks Frank. It worked.

Thanks a lot for your help!