Out of the above four records i need to select only the 3rd record.
As you can see the first 16 digits of this record is equal to the next record and the next 8 digits are different. So i want only such records whose first 16 digits are equal to the first 16 digits of next record and last 8 digits are not equal to the last 8 digits of the next record.
Please let me know how to achieve this using SORT.
Do you always have just 2 records for every key on the first 16 bytes or can you have more than that? if you have more than 2 keys how do u compare ? Also what is the LRECL and RECFM of the input dataset?
Your JCL will NOT give you the desired results as u are considering only FIRST of every record which would eliminate the 2nd record to be checked and your next select is only checking for the 8 bytes on ALL records. It should be checking based on the KEY in the first 16 bytes.
Try running your job with the following Data. Change the 1st record