Help in Soring Datasets
Posted: Thu Oct 07, 2010 9:27 pm
Hi. Im new here. Hope someone could help me.
I want to create a JCL, that would delete duplicates. However, there are 2 conditions:
First validation would be, checking of duplicates for column 6 - 9.
Second, if column 6 - 9 is a duplicate, it would check if column 1 - 4 is greater than its duplicate line. If column 1 - 4 is lower, then it would be the line that would be deleted. Im new to JCL, so please bear with my explanation.
Sample:
Input would consist of
123456789
=========
111201010
111101010
111201012
111101011
Output:
123456789
=========
111201010
111101011
111201012
*line 2 would be deleted, since its column 6 - 9 has a duplicate of line 1 Also, its column 1 - 4 has a lower value (1111) compared to the column 1 - 4 (1112) of line 1.
Please, I would really appreciate any feedbacks. Thank you.
I want to create a JCL, that would delete duplicates. However, there are 2 conditions:
First validation would be, checking of duplicates for column 6 - 9.
Second, if column 6 - 9 is a duplicate, it would check if column 1 - 4 is greater than its duplicate line. If column 1 - 4 is lower, then it would be the line that would be deleted. Im new to JCL, so please bear with my explanation.
Sample:
Input would consist of
123456789
=========
111201010
111101010
111201012
111101011
Output:
123456789
=========
111201010
111101011
111201012
*line 2 would be deleted, since its column 6 - 9 has a duplicate of line 1 Also, its column 1 - 4 has a lower value (1111) compared to the column 1 - 4 (1112) of line 1.
Please, I would really appreciate any feedbacks. Thank you.