MVSFORUMS.com

[Max]

I am writing an easytrieve program and would appreciate it if someone could advise me on how to generate a report with only the hightest( or maximum) for a given field.

Example

Field 1 Field 2
A 1
A 2
A 3
A 4

Is there a function or an easytrieve statement that I can use that will return the values below in my report:
Field1 Field2
A 4

[kolusu]

Max,

You can use the easytrive's keyword Last-dup and write out only the last duplicate.If your input file has always duplicates the following code will give you the last duplicate

[Max]

Kolusu,

You are champ! The last-dup statement returned the desired output.


On another note, in the scenario below, the last-dup statement will only return the last duplicate entry which is not necessarily the latest update for that category. What would the be the best option to pickup the latest update for each category.

Field
Loan
Category
Update Date


FILEA

Fields:

Loan|Category|UpdateDate

Values:

1|A|June 6
1|A|June 8
1|A|June 7
1|B|June 8
1|B|June 6
1|B|June 7


*** The last-dup FILEA statement will return 1|B|June 7 as the latest update. What statement would I need to use to return only the latest updates for each category:

1|A|June 8
1|B|June 8

Appreciate your help

[kolusu]

Max,

You really cannot find out the latest updated entry as the month is spelled out. you can use a SORT verb in easytrieve so as to sort the input

[Max]

Kolusu,

That would be really great if you can let me know a bit about the sort utilities. Also,
if my example above used a valid date format eg 030701(yymmdd) can I still utilise the last-dup statement to grab the lates t update date? I think the file Im reading contains an update date and time and they both are 4 P

Thanks....

[Frank Yaeger]

Max,

You can use a DFSORT/ICETOOL job like this to get the latest update for each loan and category:

[Max]

Frank,

Thanks for your help. My job has completed successfully.