IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

deleting a duplicate row


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Duplicate transid's declared using CEDA CICS 3
No new posts Deleting a Tape file JCL & VSAM 14
No new posts CA7 deleting files in steps after job... CA Products 4
No new posts Duplicate several members of/in one l... JCL & VSAM 7
No new posts Newbie Stuck on "Duplicate Datas... TSO/ISPF 5
Search our Forums:

Back to Top