MVSFORUMS.com

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

Hi,

There is a DB2 table which does not have any primary or foreign key.

There are duplicate rows in the table. Is it possible to retain one among them and delete the other duplicates by SQL queries?

Or

Should this be handled programatically using Cursors?

Please help.

Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

use some tool, it's a easy task
e.g.
unload data, DFSORT remove duplication, load back

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

videlord, Thank you for giving alterantive solution.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

mf_user,

Check the below link.

http://www.mvsforums.com/helpboards/viewtopic.php?t=1745&highlight=delete+duplicate+rows+table

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

wow. Thanks to vkphani & kolusu. It is very useful to me.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==