DUPKEYS MAX

[Prakash88]

Hi,

I need to retrieve MAX records based on two columns.

Please find my input.
Input :
A Date1 30
A Date2 40
A Date2 50
B Date1 10
B Date1 20

//SYSIN DD *
SORT FIELDS=(1,1,CH,A)
DUPKEYS MAX=(3,5,CH,9,2,ZD)
/*

Expected output :
A Date2 50
B Date1 20

It is not allowing me to give two columns in DUPKEYS MAX . Please help me.

[NicC]

You cannot do this with JCL and I presume you actually want to do it using your sort product. If this is so then let us know which sort product do you use and your post will be moved to the appropriate part of the forum.

[Akatsukami]

Why would your output not contain

Code: Select all

A Date1 30

?

[Prakash88]

I am using syncsort.

Why would your output not contain
A Date1 30

Assume date1 is day1. date2 is day2.
I always want to get latest date .

[Prakash88]

A slight change in the example given in my first post.

Input :
A Date1 70
A Date2 40
A Date2 50
B Date1 10
B Date1 20


Output :
A Date2 50
B Date1 10
B Date1 20

Can this be achieved using DUPKEYS command ?

[BillyBoyo]

You need to show the full details of what you tried, including the sysout. In the Code tags, please.