How to Delete Duplicate Rows from DB2 Table

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.