DB2

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
suree.suri
Member
Posts: 3
Joined: Wed Jul 28, 2010 5:28 pm

DB2

Post by suree.suri » Fri Aug 20, 2010 4:54 pm

i have table with duplicate records.
i want to eliminate duplicate records from this table and i want to store eliminated records in new table.

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Mon Aug 23, 2010 6:46 pm

.2 cents... one method..

Unload the data from source table. Using SORT utility remove duplicates and reload data into the table.

In above SORT condition, you can also get removed duplicates inot another file,
which can be used to load new table.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others