How to Delete Duplicate Rows from DB2 Table
There can be more than one way to deal with this situation, but here this mainframe tutorial will give you a very simple method of solving this problem.
; ; ; ;
Step 1: Unload the Table to a flat file using DB2 utility.
Step 2: SORT the file and remove duplicates.
Step 3: Empty the Table.
Step 4: Load the Table with the output of Step 2.