DFSORT Final output should not have duplicates of Column A

Redrose · New User Joined: 06 Mar 2006 Posts: 19

Hi all

,

I have a file with below format,
aaa 2 3
ddd 4 6
bbb 6 8
ccc 8 10
bbb 8 9
aaa 9 9
ccc 9 11
ddd 5 7

I need the following entries alone
aaa 9 9
bbb 8 9
ccc 9 11
ddd 5 7

i.e., Column A sorted by ascending order, Column B & C sorted by descending order. Final output should not have duplicates of Column A value. Please help me...

Regards,
Ramanan R

sridevi2005 · New User Joined: 15 Sep 2005 Posts: 42

Hi,

U can use the following code

In step1 use this sort SORT FIELDS=(1,3,CH,A,5,1,CH,D,7,2,CH,D)
In step2 use this sort
SORT FIELDS=(1,3,CH,A)
SUM FIELDS=NONE

Please check.

Thanks

Redrose · New User Joined: 06 Mar 2006 Posts: 19

Hi Sreedevi

,

Thanks for your response.

Is there anyway to execute in single step?

Regards,
Ramanan R

Frank Yaeger · Posted: Tue Oct 17, 2006 8:34 pm

Here's a DFSORT/ICETOOL job that will do what you asked for:

Redrose · New User Joined: 06 Mar 2006 Posts: 19

Dear Frank

,

Thanks for your reply. Can we use INCLUDE & INREC fields with ICETOOL as given below?

Frank Yaeger · Posted: Wed Oct 18, 2006 10:14 pm

That will work if you have z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006). You need that PTF to use INREC with SELECT. If you see 'ICE201I E' in the DFSMSG output, you have that PTF. If you see 'ICE201I 0' in the DFSMSG output, you don't have that PTF, so ask your System Programmer to install it (it's free). Alternatively, you can do the INCLUDE and INREC in a separate COPY operator before the SELECT operator (use a temporary data set as the TO for the COPY and the FROM for the SELECT).

When I ran your job with the April, 2006 DFSORT PTF, OUT had:

Redrose · New User Joined: 06 Mar 2006 Posts: 19

Thanks Frank, We don't have the PTF you mentioned. I'll ask System programmer to install it.

Regards,
Ramanan R