Joined: 07 Feb 2007
|I donno if u r looking for a solution or trying to dig up DB2.
Y dont u use a serial cursor with ORDER BY clause on all the columns with a FOR UPDATE OF clause.
Fetch first row and store the entire row in W-S.
Fetch NEXT compare it with W-S.
If equal DELETE CURRENT OF cursor.
If different move it to W-S.
Run a one time BMP like this and declare an index on all the columns to be unique to avoid duplications in future.
P.S: Do I make sense or Is my solution useless?