Re: Removing duplicate records

John,

In your case, as your duplicate records are identical, using DISTINCT for
each field is a simple (and valid!) solution.
But, what happens is even one of your fields is different, although the
Account number is the same (think of, for example, a LASTUPDATED field)?
Another problem would be if you can't allocate your table (is always in
use).

Also, I believe you could simplify Gary's idea even further by using:

CREATE TABLE mylib/wkfile AS
( SELECT DISTINCT *
FROM alib/dupfile )
WITH DATA

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries