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.