Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

deleting a duplicate row

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gireeshsk

New User


Joined: 20 Dec 2005
Posts: 6
Location: chennai

PostPosted: Tue Dec 20, 2005 8:16 pm    Post subject: deleting a duplicate row
Reply with quote

hi friends

how can i delete duplicate rows from the table retaining the original row(atleat one row of the duplicates)?

should i have to use rowid.
Back to top
View user's profile Send private message

mandyamj

New User


Joined: 22 Nov 2005
Posts: 7

PostPosted: Fri Dec 23, 2005 10:58 am    Post subject:
Reply with quote

hi,
plz give more info about this query?because if u r using tables it should contain primary key then there is no chances of duplicate record?.plz let me know if u know anything else
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Sort Card to Remove Duplicate records... raj4neo SYNCSORT 2 Wed Jan 25, 2017 4:44 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts how to find the duplicate list RAVIGUPTA1990 DB2 6 Wed Mar 30, 2016 12:11 am
No new posts Savings by Deleting Unused datasets swathykrishnan All Other Mainframe Topics 13 Fri Jul 10, 2015 6:26 pm
No new posts Issue in transfering control when Del... thesumitk CICS 10 Wed Apr 01, 2015 6:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us