On Tue, 15 Jan 2008 11:20:25 -0600, Paul Gilmartin wrote: >Related question: > >Does either product support sorting on N keys and eliminating all but >the first record with the first M (<N) values identical? E.g. for all >records with identical Names, keep only the one with the most recent >Date. >
An awkward solution would be to sort it in date sequence first, then SORT dedupe. Multiple passes and not very elegant. But for a small file, who cares ?? >I've faced this problem with Unix sort(1). It doesn't specify which >record will be retained, so I must pipe into an awk(1) script to do >the final selection. Will DFSORT operate on Unix files? > Check out SYNCSORT for UNIX. It's been a decade or so, but I'm pretty sure EQUALS is supported in SYNCSORT for UNIX. And it supports positional/variable length sort fields too. Very cool. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html